I have an SSIS package that runs fine from the Visual Studio development environment. However when I upload it to the package store and try to run it from a job the job just runs and runs and runs and runs (I've lost patience at about 20 mins) and never does anything. I know it doesn't do anything because the first step is to run a batch file that downloads some files from an FTP server. Those files never show up. I've tried running the package in VS as the account that the SQL server Agent uses and it runs fine. I've tried running the batch file while logged into the box that the SQL server agent uses and no problems there either. So permissions don't seem to be the issue. Since it never errors out I can't tell why it never does anything and if I put a short timeout it could only tell me it timed out.
Any help here would be great. I can't seem to figure out what's going on here.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred.
This will be demonstrated using Adobe Premiere Pro CS6.