Viewing 15 posts - 31 through 45 (of 120 total)
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...
September 15, 2016 at 9:24 am
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...
September 7, 2016 at 8:14 am
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...
September 7, 2016 at 7:34 am
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
September 7, 2016 at 7:25 am
Thanks, that would be great too as in this project I am not using C#, but I easily could.
September 7, 2016 at 7:20 am
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...
September 7, 2016 at 6:41 am
thanks for the response and the help. I do appreciate it
June 28, 2016 at 7:40 am
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...
June 28, 2016 at 7:29 am
I will check it and see what it shows
June 28, 2016 at 6:47 am
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:
June 28, 2016 at 6:35 am
Thanks for the link. I will check this
June 2, 2016 at 1:15 pm
I learn as the need presents itself. I stepped out of IT development at my former place of employment and took on an operations supervisor role for almost five...
April 8, 2016 at 5:38 am
Thanks! And yes, it works
March 22, 2016 at 11:20 am
I already did change the type of @WeekDay to be varchar (not date)
March 22, 2016 at 11:03 am
Thanks for this! This does start me all in the direction I need to go.
March 18, 2016 at 7:01 am