If i understand it correctly. You have files for multiple clients that needs to be loaded on defined date and timings. If these timings are fixed then you can store...

What pattern are you using to search for the files? If its just .txt then i don't see any issue. but if you are using any pattern search then it...

You need to create a flat file connection. Specify [b],[/b] as your column delimiter and {CR}{LF} as your row delimiter. You actully don't need to set all this. If you...

What exactly are you trying to do in your OnError event handler? How are you checking that its not working?

You can use Foreach loop with ADO enumerator to loop through your table and get the path for each file. If you have not used ADO enumerator befor this will...

Try

Dts.Variables.Item("StartDate").Value.ToString()

HTH

I am not sure why you wanna use SSIS when Reporting Services can do this via Subscriptions?

Reporting Services Subscriptions will allow you to send the report in any format HTML/EXCEL/PDF...

You can use derived colum to format the balance colum in desired way

RIGHT([Balance_Col],1) == "-" ? "-" + SUBSTRING([Balance_Col],1,LEN([Balance_Col]) - 1) : [Balance_Col]

HTH

~Mukti

You would need licenced version of Cozyroc to deploy on your servers.

I would just use a Execute SQL task with full resultset before the Script task to store the result set in an object type variable and then use something like...

You can use T-SQL type step at the end of your job to call the other job

e.g. exec sp_start_job @job_name = 'job name '

Else you can create a SSIS package...

Make sure that you have specified these variables in the ReadWrite varible list under Script tab in Script Task Editor. The list should be comma seperated - e.g. gvRunDt,gvPdDt,gvFileName

Yes you need to put these variable in Expressions for FromLine and ToLine property. But note that it Send Mail will keep warning you about no receipient etc. Try to...

At present there is no way to change the scope of the variable once its created from the UI. The only way is to delete and recreate the varaible with...

Try

"Enc_Unison_" + RIGHT("00" + (DT_WSTR, 10) DATEPART( "mm", GETDATE()) ,2) + RIGHT("00" + (DT_WSTR, 10) DATEPART( "dd", GETDATE()) ,2) + (DT_WSTR, 10) DATEPART( "yyyy", GETDATE()) + ".txt"

HTH