Are you looking to capture the error message? Best method I came up with was to turn on package logging and have a stored procedure extract the required text from...

Well I simplified the code a bit. It's much easier to use the convert function to generate the required date/time format for the filename. The this code ran without a...

Unless you frequent some handy underground hacking sites, you can't open the package

The better approach is to provide a bit more information

What servers are you running? Are the databases on the same server? How much...

What are your transaction settings for the package?

Do you modify the column mappings explicitly? If not then that's what you have to do. Basically you have to feed in all the Meta data that DTS automatically grabs...

Create stored procedure to capture the sizes and send the email. There should be plenty of example scripts in the Script Library.

Then put an ExecuteSQL task in between each step...

What does the package do?

I've come across this frequently when the package contains an ExecutePackage task. The only way I got around it was to start a new package from...

We use a combination of sp_makewebtask and xp_smtp_sendmail to acheive this. Eliminating any reliance on CDO and/or SQL Mail.

sp_Makewebtask generates a HTML file which is then used as the email...

If the foreign key constraint  is correct, then you need to replace the TRUNCATE statements with DELETE statements.

Sounds like you're loading directly into "production" tables, which would explain why you...

You could also take a look at the SERVERPROPERTY function in Books Online

You most likely have an ExecuteSQL task in the package that's trying to issue the TRUNCATE statement against the mentioned table. As the error message suggests, you can't truncate a...

Ok, if it "MUST" be done in T-SQL then here are a couple of methods to try,

With decimals

SELECT CONVERT(varchar(30), CONVERT(money, 1234567.890), 1)

Without decimals

SELECT SUBSTRING(CONVERT(varchar(30), CONVERT(money, 1234567.890), 1), 1
, CHARINDEX('.', CONVERT(varchar(30),...

Isn't this a presentation issue that should be defined on the client, not tying up database server resources?

The reason I raise this is because I did some work for a client that had a DTS solution involving just Excel spreadsheets and no SQL server. MS told them...