Hey everybody,
Is there any ways that I could execute a "ExecuteSQLTask" from a script task inside the package. I mean both "ExecuteSQLTask" and "ScriptTask" are in the same package.
Any tips
Thanks
Ryan
ExecuteSQLTask
Hot Topic
- Failed Install of SQL Server 2005 SP1 CTP
- Problems with SQL Task
- XML source
- Cannot connect to SQL Server 2005 June CTP
- sql:column() and uniqueidentifier
- multiple charts based on employees in report
- Active X error when trying to print
- Wait for Recieve Fails to recieve message when called from .Net sqlClient
- missing notifications
- Different Data Types in Data Source View
SQL Server
- Is it possible to have sqlcmd connect to local sqlexpress without a parameter?
- No support for SQL Server Authentication and SSIS !!!!
- Date string conversion similar to Excel's Date(year,month,day)
- SSIS import export package
- Configuration Error in roleManager in security VSS
- replication component missing error while installing Sql Mobile2005
- SQL Express Connection Issues
- how would you design this query better ( does not contain lots of code)
- How to Secure transport of file to FTP Server from SSIS...options??
- Databound image in report header
ExecuteSQLTask
tenchyz
BJT
Why do you think that being able to fire an Execute SQL Task from within a Script task will help you with this
Your best bet would be to loop over the rules using a ForEach loop and then use conditional precedence constraints within the ForEach loop to decide which Execute SQL Task to execute.
-Jamie
Microsoft Visual