How to use multiple delimiters for the same flat file source while creating the package

Hi everyone,

There is a small problem encountered while creating a package in sql
server 2005.
Actually i am using a flat file which has 820 rows and 2 columns which
are seperated by line feed(for ROW) and tab(for COLUMN).after
importing i found that ther are only 800 rows imported into the table.
Ather verifying the input file i found out that there are some null
values in the second column so there is no line feed for those
values.
Can anyone please help me how to give multiple delimiters for the same
input flat file.

SSIS parses column by column, not by row and then by column. To handle this type of issue (an improperly formatted flat file), you have to pull each row in as a single column, then parse the rows into columns yourself, checking for any error conditions.

See http://agilebi.com/cs/blogs/jwelch/archive/2007/05/08/handling-flat-files-with-varying-numbers-of-columns.aspx for an example.

|||

Hi,

Thank you for your response.But i still encounter a problem.

It is associated with READ ONLY, READ WRITE.These are the errors i am getting.Any solution for those things

|||

I need a bit more information to help you with that. What are the actual error messages, and where are they showing up?

|||

Hi,

Actually there a 2 errors and 4 warnings that are showing up when i go to the design script page itself. Before writing any code itself they are showing up. I will write you the errors. They are,

ERRORS:

1: Error 5 'Public ReadOnly Property CLASSCODE() As String' and 'Public WriteOnly Property CLASSCODE() As String' cannot overload each other because they differ only by 'ReadOnly' or 'WriteOnly'.

2: Error 6 'Public ReadOnly Property CLASSCODE_IsNull() As Boolean' and 'Public WriteOnly Property CLASSCODE_IsNull() As Boolean' cannot overload each other because they differ only by 'ReadOnly' or 'WriteOnly'.

WARNINGS:

1: Warning 1 The dependency 'EnvDTE' could not be found.

2: Warning 2 The dependency 'Microsoft.SqlServer.VSAHosting' could not be found.

3: Warning 3 The dependency 'Microsoft.SqlServer.DtsMsg' could not be found.

4: Warning 4 The dependency 'Microsoft.SqlServer.VSAHostingDT' could not be found.

Thanks in advance

|||Make sure you are not using the same name in the Input columns and the Output columns. Output column names must be different that the input column names. You should be getting a warning about this in the data flow designer as well.

On the warnings, make sure your script project has references to the assemblies.

|||

Ya i have rectified the problem and it is working fine. One more small modification that need to be done to my output table.

As said earlier there are 2 columns in my input and in the second column there are null values. But after all the scripting i find in the output table the places where i had null values,both the colunm is showing NULL VALUES. Any procedure that needs to be followed to rectify these NULL VALUES in the first column.

|||Sounds like a problem in the script - could you share what you are using?