It appears you have two different sets of information shoe-horned into the same table.  Maybe the information was derived from base tables which are more straightforward to query?  How...

• This reply was modified 4 years, 9 months ago by  pwalter83.

You're not going to want to use a Flat File Source for this. You're going to (very likely) want a Script Component, and will need to write your own...

How do you know when one data set begins and another ends? Is the first line always a different dataset to the rest, or could you have something that...

Thanks John.

I forgot to mention that this SSIS job failure is intermittent and does not occur on a regular basis.

I have tried logging to a text file but it wasnt...

The Netezza syntax is okay and equivalent of SQL server but I think I am not using it correctly in the SP.

The error I am getting is - ERROR: syntax...

You'll need to add the value of the variable first as a column, using a Derived Column Transformation (Like I showed in your other topic). Then, instead of...

Thanks very much, it helped immensely !

Hi,

Thanks.

The  file format will always remain the same with the same length. Also, the dates will always be positioned at the end.

I am using VS2010 with SQL Server 2012. Thanks.

Hi,

Please find the DDL and sample data below.

CREATE TABLE TABLE1
(
ID INT,
WEEK_NUMBER VARCHAR(10),
AUTHOR NVARCHAR(255),
COMMENTS NVARCHAR(500)
)

INSERT INTO TABLE1
VALUES('1','201905','ABC','')
INSERT...