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...

Erik Kutzler (9/1/2009)

---

A Derived Column or a Script Component would work fine.

You could also create a table in your database that stores these text values with a numeric id and...

Great, thanks for posting back.