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 |
|
NoDice
Starting Member
4 Posts |
 Posted - 2003-10-31 : 17:05:16
|
| Hi,I have a DTS package that extracts data from a flat file and loads it into an ADO recordset. As part of the flow logic I'd like to now open this recordset using an Execute SQL Task and count the rows and use that row count to determine future steps on the data. I see I can use the Execute SQL Task to return a rowcount value, but I'm not sure how I'm supposed to open the recordset in the Execute SQL Task. Is there a way, or do I need to use an ActiveX script instead. Might be a newbie question. Thanks,DJC |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2003-11-01 : 22:12:19
|
| One option would be to use the ADO RecordCount property. Another option might be to look into file manipulation via BCP/Bulk Insert. There are many great links relating to BCP/Bulk Insert on this site in the search area. |
 |
|
|
NoDice
Starting Member
4 Posts |
Posted - 2003-11-03 : 11:09:29
|
| Thanks for the input all. I'll give it a try! |
|
|
|
|
|
|
Execute SQL Task and ADO RecordSet