Well...

I got it to work. I found someone that said make the text qualifier "none".

I was then able to parse the flat file.

It is still odd...

Thank you. That makes sense.

If I am printing reports through Microsoft Office using VBA to supply the images that works well.

If I use Crystal Reports, I think I would...

Hi,

I couldn't use SSMS because it was giving me an error message. I tried but since the tables had a lot of data, I couldn't just move the columns...

By the way, what is SSMS?

I know DTS and its big brother SSIS. But what is SSMS?

Thanks,

Tony

Thanks everyone!

And yes I get it, the column order shouldn't matter.

I was just thinking of nice and neat tables all matching with same order. But as Gail said it...

Jeff,

Trust me. I said the same thing. Why does the first and second row have to start with 0x100? That was the way the application was written...

Phil / Bitbucket,

I appreciate both you helping make the transition from SQL Server 2000.

I will get the SQL Server 2005 developer edition today.

Sometime down the road I will...

Thanks BitBucket,

I've never heard of SQL Server Developer and I need to look into that. If I can't develop DTS packages (through this legacy link) in SQL Server Express...

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...