Actually it is possible to capture the out of a stored procedure in a table variable. I have been using it regularly in SQL Server 2005 for sometime now. Here...

If your in coming data is sorted according to the index specified in the destination table you get will sorted data. If, however, the data file is...

I believe you are missing user data in your old master database. Among such data is the associaton between a login and users defined within user databases. Check out...

What are you doing on the application side to manage your transactions?

I am not an ASP programmer, so I will try to help on the DB side. You need to create DTS package (easiest way is wihtin EM) which contains a...

Empty or null elements within an xml fragment fail to convert when numeric or decimal format is used, eventhough such conversion goes without a problem In a normal select...

The data bulk load operation in DTS is designed to move rows of data. It does not have capibility to perform calculations on the data ( thank god it does...

I suggest that you create a DTS package which moves data of interest from disconnected servers to a statging area where you can clean and validate the data before you...

Since your application is defaulting to mid night for time portion of the date , try using a date value without the time part (yyyy-mm-dd) in your views. This will...

You may consider using a view to the calculation for you, as shown below. All you have to do is just filter the view for the specific data of interest.

select...

After you added the new column and you choosed populate from source did you also update the transformation step to include the new column?

SQL server uses Coding Page to figure out character set properties. If you are using bulk insert task to import your data , it provides 3 choices, however, in your...

The error message seems to indicate that the DTS package cannot find anything to do under the Transfromation Task. I would suggest that your DBA test the transfromation...

Use SQL server DTS package. It allows you to specify source, any transformations you may want to do and a destination table for the incoming data. Once you create your...

You need to capture package errors ,decode them and send output to the package logfile. Below is VB code to do this (BTW the code below can generated automatically by...