I'm really sorry but Concatenating those two fields and trying to change it to a DT_DBTIMESTAMP and I get the attached error. I have not idea what I'm doing wrong.

Thanks...

Sorry Luis, I've now got the two string values concatenated - but how to I get them cast as a date in the expression?

Thanks for your perseverance with us.

Hi Luis,

Going to the Flat File Connection Manager Editor and the Advanced tab, I can see that it has split that field into two.

I renamed them Transaction Date and...

Thanks for your help. For those that want to use the following script, I ended up (with the help of someone else) with the following -

/************************************************************************************/

/*Enter the new paths...

Hi there,

This isn't changing the table that I need it to though.

I have a table called tblInterface in a database called Keystone_Train.

There is a field in the table that...

There is a table called tblInterface.

This table pulls back the following - running a SELECT -

SELECT TOP 1000 [intInterfaceId]

,[intConfigId]

...

Thanks for that - it doesn't actually update the vchConfig field though?

I've now changed SQL Server service to run under the same account of mhs2\sysadmin3 and they are now working.

I can confirm that SQL Server Agent is running as mhs2\sysadmin3. This is a domain account. It is a sysadmin account.

SQL Server is running as NT Service\MSSQL$DATAWAREHOUSE

Hi there,

I can confirm that the user is a sysadmin.

What is the recommended account to use to run these jobs?

I've just worked it out.

Thanks for your help. I really appreciate it.

Did - ALTER TABLE EOD_CAPITA_ENDOFDAY ADD UniqueID INT IDENTITY(1, 1)

Sorry I don't follow - where do I set the IDENTITY(1,1)???

Theses are the errors I receive after I run the SSIS after creating a second field in the database which is the primary key.

The field I have created is an...

More stupid questions from me. It takes a lot of effort being this dumb.

So I have a text file and I have worked out to strip the Trailer at...

Thanks for that - but ideally I don't really want to introduce another staging table.

I'm going to start reading about the "Conditional Split" that you can use in SSIS...