Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Returning Recordcounts from Datapump to a Variable in DTS
BTW, just to give back a little... If you are processing many textfiles from a single DTS package, the following modification to JohnDTampaBay's post works like a charm... You should only have to change the items in red Function Main() Dim goPackage Dim objFSO Dim objFolder...- scoutant
- Post #4
- Forum: Microsoft SQL Server: Data Transformation Services
-
TRUNCATE TABLE Fails but Table DOES Exist
You prefaced the name with dbo, so perhaps the developer that created it didn't create it as dbo.tmpFileExtract_Debit_forBryant, but rather as developer.tmpFileExtract_Debit_forBryant. When you drop and recreate the table, it will recreate as dbo since you are a sysadmin.- scoutant
- Post #8
- Forum: Microsoft SQL Server: Programming
-
Returning Recordcounts from Datapump to a Variable in DTS
You Rock, man. Thanks! This'll be much better than counting the lines in the textfile... Scott- scoutant
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
Returning Recordcounts from Datapump to a Variable in DTS
Does anyone know how to (easily) get the # of records transferred in a datapump task (similar to what is returned in the execution window). I would prefer to be able to return the value into a Global Variable. I can't run the DTS packages from VB code, however. Any help along these lines...- scoutant
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Data Transformation Services
