Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
damu_net
Starting Member
3 Posts |
 Posted - 2008-12-31 : 01:52:36
|
| Hi, I am getting problem with parameters.Here I am providing a sample case.I am pulling the data from 3 different database servers (ex: db1, db2,db3 etc..) into a single destination server. Here I am using the file connections to Execute Sql task to get the data from different servers and insert into the destination server. It is working fine with Linked server environment. Now I need to pass the server information dynamically. If I proceed with the variables, I am getting problem with connection property for execute sql task.How to proceed with this... Can anybody help me on this issue...... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-31 : 03:08:00
|
| you need to use expression bulider and map the value of variable to source connection property of execute sql task. |
 |
|
|
damu_net
Starting Member
3 Posts |
Posted - 2009-01-02 : 00:32:24
|
| Hi, Thanks for your information. But in this scenario, I am using multiple servers in the script of file connection. So, how can I proceed with the connection including multiple servers?? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-02 : 01:23:23
|
| so you're trying to process this over different servers? then what you need is a looping container like for each loop inside which you loop over servers. Inside loop get server name by means of variable using for each item enumerstor and use it for connection property by mapping in expression builder. |
|
|
|
damu_net
Starting Member
3 Posts |
Posted - 2009-01-02 : 04:03:46
|
| Hi, Thanks for ur reply. As I am new to SSIS, Can you please explain the process in elaborative manner ??? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-02 : 04:32:43
|
| see this article for illustrationhttp://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx |
|
|
|
|
|
|
parameters in multi server environment in SSIS