You need to change the connection properties of Excel connection to support mixed types.

Modify the excel connection string and add IMEX=1 to the extended properties.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1";

Task option is available at Database level, so if you right click on the database you will see task and then you can go through the wizard to load data...

Put you string in double quotes inside the expression builder

"Data Source=cost3;User ID=userABC;Provider=MSDAORA.1;Password=password;"

HTH

~Mukti

Text Qualifiers are only availble for flat files. Try tying the following syntax for replacing

REPLACE([Column 1],"\"","")

you just need to escape the double quote with a backslash

HTH

Mukti

Not sure what you want to do exactly but this might help http://msdn.microsoft.com/en-us/library/ms141214.aspx

Please post more details about what exactly you are trying to do?

Are you using environment variable (indirect configuration) to point to your config table? If yes, then it might be possible the value is not reflecting and still pointing to your...

You can add multiple address to 'To', 'CC' or 'BCC' by using following code:

myHtmlMessage.To.Add("test1@test.com")

myHtmlMessage.To.Add("test2@test.com")")

myHtmlMessage.CC.Add("test3@test.com")")

myHtmlMessage.CC.Add("test4@test.com")")

myHtmlMessage.Bcc.Add("test5@test.com")")

myHtmlMessage.Bcc.Add("test6@test.com")")

Useful link: http://www.systemnetmail.com/faq/3.2.3.aspx

You may write code to populate these values from your DB too.

HTH

~Mukti

Try the following expression:

"trial_bal_by_currency_11_SOD_1_LON_" + (DT_WSTR, 4) DATEPART( "yyyy", getdate() )

+ RIGHT("00" + (DT_WSTR, 2) DATEPART( "mm", getdate() ),2) +

RIGHT("00" + (DT_WSTR, 2) DATEPART(...

You don't need a variable to be able to set the file path in configuration. While setting up the configuration select Connection Managers-> Connectionstring(select this).

This will make the path configurable.

But...

If you are trying to run this package as job make sure that the SQL Server Agent has permission the folder where the config file is present. This is Jobs...

Hope Jamie's article answers your question:

Throwing errors from script task/component

HTH

~Mukti

Can you do a simple test? Logon to the machince using the SQL Server Agent account and from the command line try to test run the psftp.exe see if it...

You need to create package configurations for this. If you are not familiar with the concept first go through http://msdn.microsoft.com/en-us/library/ms141682.aspx

For setting up package configs follwoing article is a good start:

http://www.sqlis.com/post/Easy-Package-Configuration.aspx

When you run manually its using your credentials and when run as a job it runs under the SQL Server Agent credentials. Make sure the user under which the agent...

You can set the task result to failure and

Dts.TaskResult = Dts.Results.Failure

Then add Onerror event handler from the Event Handler tab in BIDS.

This might be helpful info for you

http://techyfreak.blogspot.com/2007/08/exception-handling-in-ssis-script-task.html