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 |
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
 Posted - 2010-06-05 : 14:24:55
|
| Is there a way to execute an SQL file withing SSIS? I know there is a execute process tool, but it seems be only for batch files and exes. thanks. |
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-06-08 : 09:39:15
|
| In case anyone is curious, I figured it out, I created a batch file that runs the sqlcmd.exe from the command prompt, then executed that from SSIS using an execute process task. |
 |
|
|
|
|
|
executing an sql file in SSIS