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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Iterate through Columns per row via Script Component
In one of the packages I am developing I would like to run data through script component and loop through columns whose names contain _CreationID and are not null or blank. I then want to and check that the column values per are the same. However I am struggling to write the vb code in the...- sauce1979
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
T-SQL Syntax for SCD Type 2
I am currently trying to complete the final part of a query that loads scd type 2 data into a dimension. Based on the data provided below I would like to produce an output that can be inserted into a dimension in addition to expiring old records and tracking history etc. The data is such that I...- sauce1979
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Read file look for text and check for a blank line
I am currently trying to import a text file into sql server. I am using SQL server 2000 DTS to read in the file. I then want to add an active X transformation task to split the file into multiple files which will then be uploaded into separate sql tables. I am using 2 active x tasks, one tocheck...
