Viewing 5 posts - 1 through 5 (of 5 total)
Thanks for the response. Your are correct database is restored from sql 2000 to sql server 2005.
I tried 1st option :
•Enable to DAC option from surface configuration
•Sp_configure...
July 1, 2009 at 4:25 pm
Thanks for all the suggestions. Finally I find the reason for failing. It is alias issue on X64 bit connecting to 32 bit.
Initially I created on only Alias under...
June 11, 2008 at 11:10 am
Yes it is Strange.
My connection string also in same format.
It works fine if I run from dtexecUI where as it fails if run from cmd or as sql...
June 10, 2008 at 10:31 am
Enviroment variable , pointing to MSDB database and table [ssis configurations]. It is able to reads values from configuration table.
June 10, 2008 at 8:36 am
Thanks for your response & sorry for the confusion.
Your are correct I am using sql server to store configuration info. All the connections are using sql user & password....
June 9, 2008 at 3:09 pm
Viewing 5 posts - 1 through 5 (of 5 total)