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 |
|
Tart_SQL
Starting Member
41 Posts |
 Posted - 2008-01-14 : 21:53:24
|
| Hi,I am executing a stored procedure with parameters in the Execute SQL Task, the problem I have is when I connect this SQL Task to a Data Flow Task (DFT) and use an OLEDB source to retrieve the variable reading in the records in an XML format, no records can be displayed because the SP is not executed until you run the package. I tried using an XML source but it won’t work either. Does any have any suggestions on what I can do in this case? Please note I only want to use SP’s in the ETL process.Thanks |
|
|
|
|
|
Execute SQL Task with procs, help!!!