March 13, 2006 at 10:30 am
I have two very small DTSX packages. One creates a new table on server A. The second grabs data from server B and creates a new table on server A.
Here's the issue: I can run the two packages sequentially from inside Visual Studio and they work perfectly. When I tried creating a job which executes the first package and then executes the second, it errors every time. I have no idea what the error is, since SQL 2005's job errors aren't explanatory at all. I also tried running the jobs from the server itself instead of my local machine and that works too. It just doesn't like the packages inside the job. Any ideas on what would cause this problem??? Thanks in advance.
March 13, 2006 at 1:28 pm
It's cool, I figured it out... It only took me 6 hours to figure out that I needed to manually edit my connection string to include the password for the user.
Still looking for a way to launch SSIS packages from the web if anyone has any input.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply