Phil,

That would be an awesome idea. I could still "develop" DTS packages but using SQL Server Express Edition.

The only problem is that I tried what you said. I...

Awesome!!

That is exactly what I needed. Hopefully these tools allow you not only read legacy DTS packages, but actually create new ones.

I will ask the boss to buy SQL...

Actually the question was can I do DTS / SSIS work with SQL Server 2005 Express?

Hi,

Thanks for all the help from everyone.

The only problem is that with SQL Server 2000, I did A LOT of DTS work. Stored procedures and DTS was the bulk...

Hi,

Thanks for both responses.

However, I didn't really get a direction from either. I probably need to ask a question or two.

1) I looked at some articles about .NET...

Well thanks for the answer.

I was hoping to do a quick query!  At least, I can saying I am learning more and more about writing DTS packages.

I need to create...

Thanks everyone.

Just when you think you've got it down pretty well...you learn something new.  I thought I knew T-SQL pretty well and have used Truncate a lot. 

I changed my...

Thanks everyone!  That was a real help!

Tony

Excellent point and that is what I did.  I add some more zeros after "us" as part of the formula.  I now have "us" plus up to 900,000 batches.

Thanks for pointing me in the...

Thanks Lowell for your help.  My batch numbers aren't arbitrary, but rather sequential.

Ninja - you were right on the money.

Thanks both of you!

Scott & PW,

Thanks for the replies.  That is what I was looking for.  It seems to me that where plausible, you use T-SQL.  I can think of times where ActiveX...

Thank you!!

That points me in the right direction and gets me started.  I appreciate that!

Tony

Thank you!!

That points me in the right direction and gets me started.  I appreciate that!

Tony

John,

That worked beautifully!!

Thanks.

Tony

Chris,

Yes it does!!!!!!!!

Thanks so much.  Now I just need to go through query to understand it and see how you came up with it. 

Thanks again.