Although I'd like to go to SQL Server 2008 when it comes out, and I may push for it in our DW project, but for our LOB apps, we've upgraded...

Would you please post the DDL for the both the source and destination tables?

😎

It may be the way your update is written. Could you post the code you are running for us to look at?

😎

Couldn't help there, hopefully some one else is more knowledgeable there. We still have have SQL Server 2000 database servers here and the developers still use EM to build...

DTS or SSIS? If i remember, in DTS you can set your batch size, but not sure if you can edit an imported (upgraded) DTS package in SSIS.

In the...

How are you importing the data, BCP, BULK INSERT?

What value are you trying to set to NULL?

SSC is one of the best SQL Server resources on the web. I have been a member for several years, and it has helped me on several occasions. ...

Personally, store a date as a date (datetime). If you store '8/29/1959' in a datetime field , it looks like 1959-08-29 00:00:00.000, and you can query the date in...

Verify that the date in @startDate is actually the date you passed. If you do this: select datediff(month, 0, getdate()) you get a return value of 1292, the number...

My first suggestion, take some time to read BOL (Books On-Line), specifically schemas. This will give you a good place to ask additional questions.

😎

Actually, this is stated in BOL.

When you build the SSIS package for deployment, you create a set of files in a deployment directory for the project, usually bin/deployment. In this directory is a manifest...

Just to be sure, when deploying your package to the production servr, did you run the Package Installation wizard by double clicking on the manifest file?

How did you accomplish the deployment to your production system?  Did you go through the build process in VS 2005?

😎