Hey AussieRock.

I had the same thing happen to me.

I was trying to find the example for you of where it happened, but I haven't been able to dig it up.

Basically,...

Ah, and I wasn't aware of SSIS.com. I'll DEFINITELY have to check that out!

I wonder why nothing has come up in any Google searches from that site....

Thanks a million Steve!

I found one example on another forum which I've managed to work most of the way through, but the end part actually doing the final query of...

Hi.

If you're trying to execute the DTS package from a job on a SQL2005 64-bit server, the problem you're probably running into is that there is a bug with the...

Thanks for the offer. I think I'm OK now.

When I FTP files from a remote site, I need to grab them according to date, which is part of the filename...

Thanks for replying, Chris.

My problem is slightly different, but I'm making progress.

I'm just gobsmacked by the lack of info I can find on FTP-ing in regard to SQL Server in...

I'm wondering the same thing. There seems to be precious little written on the subject as far as how to accomplish it!

Yeah, actually mine is a little more involved than what I noted there.

I, in fact, do insert such values into a table and then output them from there. Even the...

I always just use the Convert function (albeit in SQL2005, but I'm sure it hasn't change) to insert the appropriate date only conversion of the date. I'm sure you...

Hi.

I've already seen that article, and that was the original concept I was going for.

I'm assuming I can setup a "filname" variable using this method, but then I'm not...

Hi, I have a similar thing going on and I have used the Space function to insert standard numbers of spaces between valid fields where I need filler in my...