You can set the default language for the server: sp_configure;

or set the accounts default language: ALTER LOGIN SET DEFAULT_LANGUAGE;

or the current process, as seen above.

By using "SET ISOLATION LEVEL SERIALIZABLE" in your stored procedure, you just about guarantee the death of performance. I recently came across this bottleneck in a database having the...

Yes, I believe a calculated column is probably the way to go, and by putting the unique constraint on the pair of columns, performance would still be excellent.

Thanks for your...

Just a thought...You may want to instantiate and initialize your objects outside of your while loop and modify the properties inside the loop. Your current approach will cause for...

A few years ago I wrote an application that "documents" DTS Packages. It will create a text/html document, analyzing the important aspects of the package, connection, presedence, tasks and...

If you are 'given' a fish, you will not go hungry for the day...

If you learn 'how to' fish, you will not go hungry for a lifetime...

http://en.wikipedia.org/wiki/Data_cleansing

http://www.google.com/search?q=Data+Cleansing

-Mike

MDAC 2.8 SP2 for Windows Server 2003 is only available within the Windows Server 2003 SP1 distribution.  I have seen where MSDART.dll may sometimes exist in both Windows\System32 & several...

Export the package to a structured storage file and move the file to an accessable location to the second server.

I have seen this error when you attempt to set a VBScript variant to a SQL Decimal without explicitly converting it to a Double.  HTH

try changing the line....

strSQL  = "SELECT * FROM blue.dbo."& strTableName

to

strSQL  = "SELECT [Timestamp], [CallEvent] .... ,[Site] FROM blue.dbo."& strTableName

Have you also considered using an Active-X task that instanciates a "scripting.filesystemobject" and uses either the CopyFile or MoveFile methods?

There are may ways to perform this task....

Just a thought... Are you calling the sp_OADestroy method for the object you are creating with all sp_OACreate methods?  Also, what are the @oPKG & @Cmd variables set to?  I...

You may want to check if there is any exclusive locks on your MSDB database during this situation.  Also, start a trace to understand what command is causing the blocking.

-Mike...

Your Dynamic Properties task needs to be at the highest order of precedence.  Your first task should be attached from the Dynamic Prop. Task with an On Complete

-Mike Gercevich

Three things to check.

1) IIS Script Execution Timeout.

2) SQL Server connection timeout.

3) depending on how your are initiating the execution on the package, SQL Command execution timeout.

For longer running packages,...