can i not use th loop trough container to read through each row

This is a more detailed description of what I am trying to achieve, Im faily new to SISS.

I have a Excel 2007 file with 187999 rows of data (as shown...

this is all part of the same package, what I trying to do is delete a record in a table relating to the raw file record, the sql query iam...

What is the syntax to pass a raw file variable to sql parameter

hi SSC Rookie

Yhanks for your solution

is there a way of using a use a raw file instead of a Temp_update table.

what the sql be for that

Here is a sample of the data I am trying to update

"21,""U"",8,100012714788,1,2,2001-04-18,""ZW"",,367903.00,403212.00,1,4250,2001-04-18,,2008-04-07,2001-04-18,"""",""00BWGG"","""",,,"""""

The U stands for an update, there are other codes for Insert (I) and Delete (D) but I have...

This a sample of my package, I have changed extension to txt from dtsx.

Hope this is enough.

Cheers

This might be a simple question but how do I upload it

Yes I want to use the RAW file as a source and then update records in the database (tried using TSQL update but not sure about how to get the...