I am also facing same problem for if use token 'A-DBN'. In this case i get this in output

Current database name is [SQLSTATE 01000]

but, surprisingly other tokens like MACH &...

Superb Article...

You can use CABARC.exe. It is freeware and it can compress large files.

I have found the solution of problem.

If you have installed service pack 3a the dts designer gives error.

Solution : install service pack 4 fo sql server.

You can use activex script task.

Suppose the path of excel file is "c:\DTS" and you want name of zip file as DTS.ZIP

This script will zip all the files from folder.

*******************************************

Function...

Thanks For helping me.

yoc can have a activex script task which checks if file exists then it is not doing any thisng just write this

Main = DTSTaskExecResult_Success

else, you can skip one task...

You can use SQL BULK INSERT statement, bcp. The T-SQL BULK INSERT statement can potentially perform faster than the others because BULK INSERT executes completely within the SQL Server...