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

Huh??? The quotation backs up what Jeffrey says.

Here is a direct quotation from "Professional SQL Server 2005 Integration Services" regarding this:

As for SSIS, you'll have to use at least Standard Edition to receive the bulk of the...

You do not need to extract data into a holding area first - just do it all in one statement, eg (untested):

INSERT into [dbname].[schema].target(Field1, Field2, ... Fieldn)

SELECT Field1, Field2, ......

This would seem to come down to MS's definition of 'standard' and 'advanced' transforms - has anyone seen them listed/categorised one by one?

That was a constructive comment, in my opinion. Perhaps a little terse.

It seems that you already know exactly what you want to do and how it should be implemented. I...

You really are new!

I suggest that you search around on the Internet for something like "Creating your first SSIS package" to find the sort of step-by-step detail that you are...

If both of your tables are in SQL Server, just issue the relevant INSERT and UPDATE queries using Execute SQL tasks ...

Or avoid SSIS completely and use a standard SQL...