Try adding a Data Viewer to confirm that the dodgy data is not being returned by the SP.

For some reason, all of your source data is being treated as text. If source data is properly recognised as numeric, the text qualifier will not be applied to it.

To...

OK, good - that makes it clear. I can think of two ways:

1) Import your data to a staging table in SQL Server and then use a UNION query to...

OK, I misunderstood the requirement.

Can you give sample before (source) and after (required format) data please - just one example should be enough for me to picture it - thanks.

Add a derived column transformation after the merge to give you the data as you want.

Derived column works well.

Create a new column with a formula like this:

[SourceTextDateTimeField]

and give it a datatype of DT_DBDATE. This casts the string to a date and strips away the time...

You will have two dataflows appearing on your Control Flow - simply join (a) to (b) and you can be sure that (b) will execute after (a).

Not sure that helps...

If your flat file date format is already in the format

YYYY-MM-DD HH:MM

it is in perfect shape for loading direct into a SQL Server datetime field and you should be able...

Unless you post sample data, as ruizeddy already requested above, no one will be able to give you detailed help.

To use the graphical mapping tools in SSIS, it needs to extract the source and target metadata from an existing table/file ... hence your problem.

Can you explain why you cannot...

This thread might help you:

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/7172223f-acbe-4472-8cdf-feec80fd2e64

Try removing the Read/Write variable and running again.

By explicitly mentioning the variables there, you can access them using the

dts.variables collection.

However, as you are using variabledispenser, you can access the...

You can do this by using a variable and two Execute SQL tasks.

1) Create your variable first

2) The first Execute SQL task retrieves the CategoryID and assigns it to the...

No need for row by row, wash your mouth out! 🙂 Just use an INNER JOIN on both fields for the update (run this first).

UPDATE t

Set field1 = s.field1, field2...

None of the items in that list of advanced features is needed for the bulk of SSIS tasks - so you appear to be contradicting yourself.

Eg, from one of your...