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!
-
Iterate through Columns per row via Script Component
hey I actually managed to get this working with some tweaking. I used a derived column transform to create a field that concatenates the lookup fields with a semi colon delimeter. The expression was as follows: (ISNULL(F_CreationID) ? "" : F_CreationID) + ";" + (ISNULL(Ind_CreationID) ? "" ...- sauce1979
- Post #4
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Iterate through Columns per row via Script Component
TO HELP GIVE A BETTER PICTURE OF THE SITUATION I HAVE ADDED SOME TEST DATA CREATE TABLE #TEST( AUTOMATCHID INT IDENTITY (1,1) NOT NULL , A_CREATIONID VARCHAR(20) NULL , B_CREATIONID VARCHAR(20) NULL , C_CREATIONID VARCHAR(20) NULL , D_CREATIONID VARCHAR(20) NULL , E_CREATIONID VARCHAR(20)...- sauce1979
- Post #2
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
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
will do. thanks again -
Read file look for text and check for a blank line
I understand what you are saying. I just forgot to mention that the text file is an Essbase hierarchy meta data extraction. Hence i will always know the format of the extraction. In this case the extraction that I make will only have one occurrence of [ownership] as a line on its own. Also I... -
Read file look for text and check for a blank line
THANKS A LOT. THATS SEEMS TO HAVE DONE THE TRICK. MUCH APPRECIATED. -
Read file look for text and check for a blank line
I have tried to use the blueprint given above to add the blank Line but my amendment now blanks the file I want to write to. The code is : ' Pkg 211 (File Exists - 1) ' Option Explicit Function Main() Dim oFSO, sFileName,objTS,strLine,NextstrLine,ts Const ForReading = 1... -
Read file look for text and check for a blank line
Many thanks. I think I should be able to take it from here. Much appreciated. -
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...
