| Author |
Topic |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2010-09-01 : 11:18:54
|
| I have a package that consists ofOLE DB Source & and File Destination within the Data flow tabThen i have an FTP Task within the Control Flow tab.When i run the package manualy, it works fine.when i am logged out, it fails on a schedualed task.Does anyone have any ideas on why this is happening.Kind RegardsRobMCTS / MCITP certified |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-01 : 11:56:33
|
| make sure sql agent account has permissions. also, where is ssis package stored and what security mode did you set for it? i always use "Rely on Storage and Roles"finally, and most importantly, what is the exact error message you're seeing? |
 |
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2010-09-02 : 05:08:01
|
| Now i have come into work today, and when i run the package manually it fails. and i receive the following messageError: 0xC001602A at Package, Connection manager "FTP Connection Manager": An error occurred in the requested FTP operation. Detailed error description: The password was not allowed.Error: 0xC002918F at FTP Task, FTP Task: Unable to connect to FTP server using "FTP Connection Manager".Task failed: FTP TaskWarning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.SSIS package "Package.dtsx" finished: Failure.The program '[6944] Package.dtsx: DTS' has exited with code 0 (0x0). |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2010-09-02 : 05:53:09
|
| Have worked out the latest problem, but still can not get it to work manually. where abouts will i find the setting for "Rely on Storage and Roles" |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-02 : 13:24:12
|
| seems you're not able to make the FTP connection. how are you passing credentials to ftp server? |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2010-09-06 : 08:02:24
|
| I have created an FTP Connection with the FTP Connection Manager and have filled in the server settings and Credentials.The credentials have the correct user name and password. When i test connection, it is fine.But if i come back to the FTP Connection Manager Editor after i have cicked OK. The password box is empty.I know the credentials are correct becuase the package runs fine when i run it manualy. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2010-09-14 : 03:48:46
|
| Does anyone have any ideas of what is wrong here |
|
|
|
squashjunkie
Starting Member
9 Posts |
Posted - 2010-10-04 : 05:36:30
|
| I have encountered this a few times. You can increase the security settings on your package to "Encrypt All with Password", which will then store the FTP server password successfully for you. Don't worry about the password field being blank, this is normal once you re-open the connection.... You will then have to use the same password to schedule the job in the SQL Agent, which should run successfully."Do or do not. There is no try" |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2011-06-24 : 09:11:45
|
| where abouts in the SQL Agent job. would i enter the password ?? |
|
|
|
|
Package not working when logged out