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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-09-25 : 04:02:00
|
| Hi,I'm using the Execute SQL Task in my package where i need to execute the script from the variable that will be generated dynamically.@user:variablename = filename.sqlI mean the SQLSourceType = Variable and the Variable = d:\test\script.sql. when i execute the package it failed.Can anyone tell me how to execute the SQL Task if the sourcetype is variable and variable holds the path of the SQL script that needs to be invoked.Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-25 : 14:32:06
|
| then what you need to do is to use a for each file enumerator to read the contents of file (query) from path and store it a variable and then pass it to execute sql task |
 |
|
|
|
|
|
Execute SQL Task