Another option is to execute the data flow task without any conversions, then execute an update afterwards, to update the data as such:

update MYTABLE set [DATE_FIELD] = CONVERT(VARCHAR(12), [DATE_FIELD], 107)...

The connection was set up with the gui through the new connections option of the "(connect to server and Get databases)" Execute sql task. You can specify the local...

It is nice to know someone else out there is working on something similar to what I am working on. Please see my sample attached. I hope it...

Not sure if this is what you are looking for, but I have used this method to create memory tables to temporarily store data.

declare @dbs as varchar(100)

declare @recmodeltbl...

You cannot use dynamic queries with openrowset. You will need to create the entire statement using a variable and then execute the variable. below are two examples:

SAMPLE 1

--------------------------------------------------------------------------------------

declare...

Please post a sample of the file.

Try changing the datatype for batchid from string to int64.

I wound up using:

Dim strConnect As String

strConnect = "Data Source=" + Dts.Variables("User::currentserver").Value.ToString + ";Provider=SQLNCLI.1;Integrated...

Thanks!

Can you elaborate on how to do this please? I have a similar issue, and I just recently started using SSIS.