March 18, 2011 at 9:35 am
Hi !
I have the list of server names in a dataset and i connected it to for each loop container and with in the each loop container i have place the dataflow.
now i need to connect to each server and run same query on all servers .can some guide me here with step step .... thanks in advance 🙂
March 19, 2011 at 9:31 am
Hi!
1) I had One Execute SQL Task and get the list of servers and stores in a dataset variable object
2)and next for each loop configured.
3)Inside for each loop i had dataflow and source configured to local host
4)for local host connection in expression i have given servername to variable "ServerName=@[User::VServer_NM]" defined in the for each loop where it has server names
5) but the package is running with no results in the destination server
can some one shade light on this ??? thanks in advance
March 19, 2011 at 10:12 am
March 19, 2011 at 1:09 pm
Hi i was trying to make the expression for connection string like below but still i am not getting the data .. is there any issue with my connection string below thanks in advance
"Data Source= "+@[User::VServer_NM] +";Initial Catalog=master;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Application Name=SSIS-SQLTopology-{BA2B2D52-06B7-4709-B605-247AC7D27CAD}L3NGQSJ1.master;"
March 19, 2011 at 1:24 pm
Check out http://www.connectionstrings.com
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 19, 2011 at 1:24 pm
Check out http://www.connectionstrings.com
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply