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! 🙂

satish.t (9/10/2009)

---

Hi Mike...

I need some more info...I suppose ur using checkpoint feature

1. You must have developed the pacakge on your development system and deployed on server. So the path of...

Is it that you are interpreting the error message as meaning that there is definitely a codepage problem?

It is more likely that you are experiencing data truncation. What is the...

Actually, make sure you've got an

Imports System.IO

and then you should be able to

File.Delete(filespec)

without the need for the FSO.

FSO needs a datatype in the Dim statement ...

matthew_charron (9/2/2009)

---

If you are using an execute sql task to dynamically create the source table then you could use that same statement in an execute sql task to create a...

I just had a thought about this - why not set up an Excel spreadsheet (or CSV file) and redirect any missing departments to that?

Then include the spreadsheet as an...

Just follow the link provided by CozyRoc and you will see what the trash destination is and how you use it.

I deliberately avoided that question, because I don't know the answer!

The necessary 'machinery' for dataflow failure is obviously in place (FailPackage..., FailParent, ForceExecution...) and maybe you can get at these...

Maybe you could do it this way - though it does require (in the case of no missing departments) two reads of the source data:

1) Data flow task 1 retrieves...