Viewing 6 posts - 1 through 6 (of 6 total)
Thanks that did it and it works fine now. I guess the command line was different from server to server. Thanks again !
September 23, 2008 at 11:30 am
There is test data because when I go legacy -> data transformation services
-> right click the package name, open the package in 2K5 and run the same package...
September 23, 2008 at 9:12 am
The source is 2K5 and the destination is 2K. Yes, I did modify the database to point to a test server instead of a production server to make sure it...
September 22, 2008 at 9:35 am
How do I find out what user is being used when the package is running? I thought it was the onwer of the package a domain admin account but I...
August 20, 2008 at 11:50 am
The error was Select permission was denied the object 'sysjob', database 'msdb', schema 'dbo'.
What do I do now?
August 19, 2008 at 9:58 am
Are you connecting to SQL 2k with the same credentials? eg sa?
YES
can you select * From sysjobs on the msdb from within ssis?
NO
What does that mean?
August 19, 2008 at 9:27 am
Viewing 6 posts - 1 through 6 (of 6 total)