Viewing 15 posts - 256 through 270 (of 295 total)
Yes. Sorry. I was waiting on response on the other thread and thought I might have used the wrong forum. Thanks again.
February 23, 2012 at 7:37 am
Anybody can help here? I would really appreiciate it.
February 23, 2012 at 7:30 am
I tired that. But this won't return anything.
February 23, 2012 at 7:28 am
I think i will do a fresh install of 2008 R2; and here will be my steps..Please correct me if I miss out anything.
1) Backup/detach databases from 2005.
2) Script out...
February 17, 2012 at 2:46 pm
Thanks for the information. Does SQL server stores the hung state in any of its tables?
February 17, 2012 at 7:06 am
Sweet. Is there any easy way to upload them in the server as well or just manually upload them one by one?
Also, since I am a newbeie on this what...
February 17, 2012 at 6:30 am
Sorry...How do I run this? Through Powershell?
February 16, 2012 at 1:51 pm
OK. Then how about SSIS? I have lots of SSIS in 2005. Will they be upgraded when I restore msdb to 2008R2?
February 16, 2012 at 9:19 am
No. Acutually only one instance => 2008R2. Upgrade 2005 to 2008R2 and maintain only one instance but in Z drive (not on C drive where 2005 currently is).
February 16, 2012 at 9:10 am
There isn't any linked server setup and DTS works but SSIS doesn't
February 13, 2012 at 3:18 pm
Another thing to note is that DTS uses a sql login but SSSI uses a service account. But that still doesn't explain why it wouldn't error out (can't find linked...
February 13, 2012 at 3:10 pm
No. Same error.
Question is: why NO error regarding linked server in DTS but error in SSIS?
February 13, 2012 at 3:01 pm
Connection is pointing to remote server, which is configured to connect through service account.
Stored proc on remote server references a linked server to the calling server (where the package resides)..But...
February 13, 2012 at 2:42 pm
Yes That is correct, I use Execute SQl task to execute the stored proc.
Through the SSIS, a service account is used to access the remote box. What do you mean...
February 13, 2012 at 1:47 pm
Viewing 15 posts - 256 through 270 (of 295 total)