How much data are you exporting? If it's not a huge number of rows you could quite easily use DTS to output to a text destination. BCP is faster on text...

There is a line in the VB code that you can uncomment to rave the package back to SQL Server.

You could do something like this ugly bit of code,

DECLARE @acc char(15)
SET @acc = '1234567890ABCDE'

SELECT 
 @Acc as Account
 , SUBSTRING(@acc, 1, 1) as Char1
 , SUBSTRING(@acc, 2, 1) as Char2
 ,...

Yes you could do this by writing you own program. You can't alter the statis output of a precompiled program

Disconnected edit will check the connections in the package before the dialog opens. You probably have a connection that references a file that can't be found. Maybe a UDL file...

The "correct" method would depend on your operating environment and what sort of change control process you follow.

The method you've outlined will work, but bear in mind that unless you've...

Pat

Check your previous post on this same topic.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=4&messageid=176325

If you have any specific questions rather that just general requests please state them. What specifically don't you understand about the information...

Why not use 'Database Mail' that comes with SQL 2005??

Pat

As I've mentioned previously, It'll probably help you frame your questiosn better if you do a bit of research for yourself before coming to the forum with sucha broad question.

A...

I think I recall reading somwhere that GetExecutionErrorInfo doesn't work within the package. You'll need to wrap it in a DLL to get it to work.

Personally, I have package logging...

Mike

Yes you could do that, but as you've already pointed out, parallel execution brings it undone

What would have been really nice was a...

Why do you need a seperate script that will contain everything that a backup will contain anyway?

Why not just take a backup of the database?

Also FYI, heres SQL Server 2005 x64

Microsoft SQL Server 2005 - 9.00.1116 (X64)

 Apr  9 2005 20:59:14

 Copyright (c) 1988-2004 Microsoft Corporation

 Beta Edition (64-bit) on Windows NT 5.2 (Build 3790:...

Last time I looked "Now()" wasn't an SQL Server function. Are you doing this in code?

For SQL Server you would have either,

SELECT GetDate()-30
SELECT DATEADD(dd, -30, GetDate())