We do a lot of date cleansing within our DTS packages, but we use T-SQL to do it. Use the datepart function to do this. Example:

select datepart(yyyyy, MyDate)...

Well, yes, QA is free, but hey, if my company will spend the money, what the heck!!

We are looking for something with VSS intergration - RapidSQL and MssqlXpress both do...

We use Global Variables along with a case statement to change the Server and Database information in production. The following code is put into a ActiveX script that is...

What type of error are you receiving? We import files with millions of rows with no problems.

Diane

Steve,

Have you ever used the serverproperty function to return version information?

Example:

select serverproperty('ProductVersion'), serverproperty('ProductLevel')

will return the version and SP number.

Diane

What is the error message you received when the DTS package fails?

Diane

I just accepted a database development job that includes working with Data Warehousing and SQL Server Analysis Services. But I took a pay cut to get into it. ...

Set up the remote server as a linked server on your local server. SQL Server Books Online (help files) will show you how to do this.

Then use the following...

Here is the list:

http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4

Diane

Double click on the job and look in the description text box. When a DTS package is scheduled, this is automatically filled in. The package name should be their...

In the shops I've worked in, I usually refresh the development database with a backup copy of production. After the refresh the developer would apply any "In progress" changes...

Thanks to all for your replies.

Matt - I'm looking at the Entegra product but I think the price may be too steep ($5000) for my client.

Thanks,

Diane

Are you referring to a stored procedure?

Maybe. If all your db calls are via a stored procedure than yes, they will collect the same data. If you are sending any plain SQL to the...

select db_name()

will give you the current database name

Diane