[Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute] public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase { public void Main() { // TODO: Add your code here var directory = new DirectoryInfo(Dts.Variables["User::VarFolderPath"].Value.ToString()); Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total. However, converting data into a correct CSV file is ambigeous. A simple VB Script to convert your multiple Excel (xls) files to CSV format quickly. Ramesh, There is this possible soultion. So, learn the steps below to Transform Excel to CSV UTF-8 without Destroying Special Characters. And the excel window also closes. I don't know who to give credit to, its from a combination of scripters that I no longer remember where I got it from.