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.

It sounds like you are trying to create the output file meta data (ie, the column names and data types) dynamically, is that correct?

This isn't really how SSIS works -...

I imagine that this would evoke a better response if it were posted in the BI forum, as it's not really SSIS-related.

You have a sub called Button303_Click with no obvious means by which it will ever be executed - where did this code come from, a Windows Forms VB.NET project, perhaps?

You...

Based on the sample data and code, I cannot see why it would not work for you, as you appear to be doing the right things.

Or, as you are in...