Nope, I did not mean to sound defensive in anyway at all and sorry if I came across that way

thanks for the response. I actually think it was the table that I was querying against as it stored millions of records. I changed to a different version...

Yep, it looks okay. In doing further investigation and trying to trace the issue through execution results, it looks like the permissions on the destination table changed somehow. ...

Nope, I deleted the whole Data flow, recreated it and still the same. And this is with a new refreshed tsv file too. I waited yesterday thinking maybe...

Thanks Phil, I will try that. I did recreate the destination, but not the source. The only thing I did there was refresh the columns. I will...

I guess I don't understand, but each month it runs, it would be a unique file name. So next month it should be something like 20161001.csv. In November...

In this use case we would not need to do an overwrite (not that I am aware of yet). This is a file that will be run once a...

Is it as simple as doing this: System.IO.File.Move(@"C:\From.txt", @"C:\TO.txt"); ?

Except I need the "TO.txt" file to be YYYYMMDD.csv

Thanks, that would be great too as in this project I am not using C#, but I easily could.

Thanks and that is the direction I was just looking at, using the File System Task to manipulate that filename after the processing was done. I just now need...

thanks for the response and the help. I do appreciate it

I checked with the profiler, but there is a LOT going on with this SQL server so what I did, and this does work for some reason, is built a...

I will check it and see what it shows

Yep, no triggers and the datetime is being sent from the code as follows: #6/28/2016 08:33:14 AM#, but the resulting row in the database table is:

ActivityLogID ...

Thanks for the link. I will check this