If i understand correctly, you want to process bunch of files and then move them to different folders based on some criteria.. is that correct?

As lausen states there are plenty of resources for SSIS compared to any other tool, which makes it easy for anyone out there to learn it easily and Of course...

Phil Parkin (5/7/2010)

---

Oooh, so you did...

Kari Suresh (5/7/2010)

---

yep, got it..!

Finally I removed mapping in parameter mapping tab of my execute sql task package and used expressions to get it.

Created total three variables.

One for stored procedure,...

Try this EXEC BIW_Status ?, ? and map the parameters correctly

Is it possible to post some screen shots here ??

That's right Phil. I completely forgot about it,...

Your assumption is true.. but before going ahead did you check your updated table for those records. Do you see them?

Chris can you at least identify the missing rows from your flat file and post them.

Suresh,

Look at the links below on how to map the Parameters using Execute SQL tasks. Also, try using an Expression...

I agree with Phill. Post your good and bad rows from the data Viewer here. so, some one can lead you in a right direction...

Did you add the SQL OLEDB Connection to the Script Task Connection Manager ? Use that connection Manager Name in the script task

elchuru (5/3/2010)

---

Hi,

I created a variable with name 'source_file' with string data type and default value is 'C:\test'. In my expression i want only 'test'.How to extract only "test"...

Rex do you have the same problem as SNookala.. If so, 1st thing change the data type of Column0 in the text file to String and then use the expression...

Hi,

The link below should help you to get the list and you can then store it a variable, use it in an Expression in Derived column to add the table...