Hi,

I have an error when importing:

- Copying to [dbo].[topfinance3] (Error)

Messages

Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE...

From a flat file.

There are no error messages, it just changes the type to string, and if i change the type to date, it cuts off the timestamp at the...

I'm using the import function under the DB table - so the only options i have are just the standard Data Types.

i've done the expressions for the connection string and that works fine - but how would I could go about running incremental files ...so i would run the job one...

Hi

the files are the same format and will be called something like "file1", "file2", "file3", "file4" and so on.

How would i created the file connection manager string dynamic?

thank you

Hi,

Thank you for that,

i've had tried that, that works fine.

The only think is that, is there anyway to update the SQL query dynamically, for instance update the .sql file in...