Viewing 6 posts - 1 through 6 (of 6 total)
Create link server - it helps there.
Are both servers 2005 + ? Except didnt work in SQL Server 2000.
June 20, 2011 at 8:54 am
Just iterate on all host and make dynamic connection for each host you have using Script Task Editor.
ie.
Dts.Connections["DBConnection"].ConnectionString = "Data Source=" + Dts.Variables["YourHostnameVariable"].Value + ";Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;";
Then just use DBConnection...
June 20, 2011 at 8:41 am
Read about XML Configuration files. It makes the job when moving SSIS from dev to prod.
May 25, 2011 at 8:51 am
Add Script Task and change file permissions before and after reading/writting it.
January 28, 2011 at 1:16 pm
I do not know what you mean exactly but if you mean SSAS properties you can use DMV views.
January 28, 2011 at 1:06 pm
Use sql script task to generate variable and then use it like a filename.
January 28, 2011 at 1:04 pm
Viewing 6 posts - 1 through 6 (of 6 total)