Thanks Cleko

I knew about the Insert statement, that is nice. I simply created one and then copied and pasted the others. I do use it in my production code, and...

Thank You

I thought that I had tried it that way, and it had a syntax error. I have tried so many things, my mind is all mush now.

That worked perfectly

Thanks...

Change the column to the correct data type. Then you can perform calculations like you should be able too. Find the person that designed that table, and beat their ***...

Gail

Good to know.

Thanks

Andrew

There are so many dependencies for this, I just don't know where to begin.

How is the design of the database? Are the columns properly indexed? What kid of queries are...

Thanks Gail

Looks good

Andrew

I would suggest that you remove, or at least turn off the services for Express. If you have SQL Server, you do not need to be wasting time on trying...

How are you receiving a JET error when you are using an OLEDB Connection?

Simply just delete the package and start over.

This stuff is really simple.

Right click on the table...

Mark

What they are talking about, is that the Logs and the data files need to be on different spindles, not different drive letters. There is a huge difference.

If you have...

Yes, you need to select "Excel File" when you select the Destination. You must be selecting "Flat File" or something. There is a long list of different connectors

Andrew SQLDBA

OK, you posted this into a SQL 2005 area, so I assumed this was for SQL 2005

I created a simple DTS package in about 2 minutes by using the wizard,...

Ok, a couple things:

Why would you not use a SSIS package, to run the query, and then pump the data out to any file type that you like?

second:

Why are you...

Ok, is there an IFCode shortcut for <Totally Embarrassed>

I misspelled the database name.

It is beginning to feel more like a monday now.

Andrew SQLDBA

OK, neither of those tables exist in SQL 2008. Do you happen to know the table names for SQL 2008?

Thanks

Andrew SQLDBA

Very nice, I will give that a look

Thank you for your advice.

Andrew SQLDBA