Sounds like you got it working well - good stuff:cool:

An example of your input data would paint the picture much more completely than just words, no matter how detailed your verbal explanation ... So far I have a picture...

Use an Execute SQL task (select count(*) from ...) to assign the count to a package variable (which you will have to create) at control flow level and then use...

Or possibly (thinking a level up) a parent package that concurrently runs multiple occurrences of the same child package, with appropriate parameters.

I haven't tried that - and it doesn't sound...

Or put some other unused character there...

Assuming that the text files are the same format (same field names, types, number of fields) you can use a FOREACH loop to iterate round the files.

But I'm not going...

🙂 happens to us all

Just add the single quotes in ...

"UPDATE TB_DMNSTAGE SET DMN_STATUS = '" + @[User::DMNSTATUS] + "' WHERE DMN_ID = " + @[User::DMNID]

You could use an OLEDB Command transformation to do the update for you.

Or you could send the rows to a staging area and then run an UPDATE to do them...

This is somewhat similar to telling someone that your car is not working and asking whether anyone knows how to fix it.

Please provide more details, error messages etc, so that...

Easier and cheaper to get an IT-literate temp in for a week, I reckon.

Sometimes the development effort for a one-off task such as this just isn't worth it, IMO. But...

Create a blank Excel 'template' file - contains just the field names.

0) Copy this file to, say, ID.xls and create a connection in SSIS to ID.xls.

Your dataflow task in your...

Or that the pipeline meta-data column definition is too small.

saidwarak01 (9/11/2009)

---

Hi Everyone,

I have an assignment like this....

I have table with 100 thousand records with 20 columns and among them there is one column called shcool_id. Now, the...

I feel like I'm fighting a losing battle now, but the post I suggested was three above my original post and it mentioned that this was a duplicate thread! 🙂