Viewing 13 posts - 31 through 43 (of 43 total)
Hi,
I agree you should try to execute the DTS package directly. A feature on SQL2000 that I love is that you can right click on each task of the DTS...
April 13, 2005 at 9:00 am
Sorry,
I just scanned the responses for the word "function".
teague
April 1, 2005 at 8:08 am
Hi,
This returns a date sans the time. Since it returns a smalldatetime, there is going to be a time component. In this case 00:00:00; no way around that. If you...
April 1, 2005 at 7:53 am
Hi,
I'm making guesses....are you maybe zooming through all the files and processing only the last one? You might think you are on the first one but have ended up at...
March 30, 2005 at 8:15 am
Thanks,
I got the type command from the resident DOS guy....does everybody have one of those?
March 17, 2005 at 10:19 am
I have used Phil's approach in my packages as well. I indicate the server via the dtsrun command. Using that table driven method, I pull in paths for source files,...
March 17, 2005 at 9:30 am
Your final kludgy solution was the one I ended up doing when faced with essentially the same problem. In my case I was appending a trailer record instead of a header...
March 17, 2005 at 9:15 am
Marvin is right about dts getting out of whack dealing with open files. Once you get your transformation tasks set up, right click on the transformation line, click on WorkFlow...
February 8, 2005 at 12:00 pm
It may not be possible in your situation but if you can get the people on the FoxPro side to issue that nifty "PACK" command when they delete something, you...
January 24, 2005 at 12:07 pm
I do some flag swapping that sounds similiar to what you want. The flag swapping is between my process and another process that feeds me...
January 6, 2005 at 9:36 am
That makes me sad.
But, thanks for replying!
Tig
April 22, 2004 at 12:54 pm
This is for development. I guess what I am looking for is the same functionality you get when working out of the repository; the ablity to double click on the...
April 22, 2004 at 11:07 am
I ended up having to first move the data into a table with all the date columns typed as Char. Then, you can check the dates to make sure they...
March 10, 2004 at 7:13 am
Viewing 13 posts - 31 through 43 (of 43 total)