Unable to schedule an ssis package WHICH RETRIEVES data from MYSQL

0

I've created an SSIS PACKAGE on machine X to retrieve data from MYSQL DB Query from machine Y and write to an SQLSERVER Destination Table which is on machine Z(compulsions since I am unable to connect to mysql from Z and X is the only machine which has navicat).

The package runs to the T when run manually and I'm trying to schedule it on machine X for Z's DB .I've created the xml configuration file and placed it on Z since the process runs on Z's DB.and the job fails when executing as a scheduled Job.

I've added passwords to the config file as they don't save automatically.

I suppose it's due to different machines being used(Package on X running on Z's DB and config file on Z).

Here's the error: Failed to open package file "D:\CSMS\SSIS\Random\Random\MySQlDBtoDWH11DataTransfer.dtsx" due to error 0x80070015 "The device is not ready." This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format. End Error Could not load package "D:\CSMS\SSIS\Random\Random\MySQlDBtoDWH11DataTransfer.dtsx" because of error 0xC0011002. Description: Failed to open package file "D:\CSMS\SSIS\Random\Random\MySQlDBtoDWH11DataTransfer.dtsx" due to error 0x80070015 "The device is not ready." This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.

Unable to understand where I'm failing!

mysql
sql-server
ssis
mysql-workbench
xml-configuration
asked on Stack Overflow Dec 30, 2013 by VJAI • edited Dec 30, 2013 by Suresh Kamrushi

2 Answers

0

Are you using Direct configuration or using Indirect( in which your xml config file path is saved in Environmental variable?

IF you are using Direct configuration, you need to make sure your both machines have the same folder structure which is saved in package.

If you are using Environment variable to point to configuration file. Make sure you have changed the value of variable according to machines and folders where your configuration file is.

answered on Stack Overflow Dec 30, 2013 by Ashahzad • edited Dec 30, 2013 by billinkc
0

To close this question,I've scheduled it to run from a batch file and the process is running fine.

answered on Stack Overflow Jun 5, 2014 by VJAI

User contributions licensed under CC BY-SA 3.0