In your first post you mentioned that your are trying to run exec crimes.loadStatute.

Please make sure that in the loop you are using the Schema name properly and not...

I am suspecting that you are getting some NULL values in your ADO resultset. Make sure that the ADO resultset (in foreach loop) does not get any NULL values. If...

What error do you get when you pass parameters? If your parameter variable is of type Int34 or Int64 map it to 'LONG' type in the Parameter Mapping.

Also Paramter...

Yes SSIS won't be able to return null value in a date time variable. Also I am not sure why its returning a particular date when the value is NULL....

You will have to escape '\' character. Try

SUBSTRING( @[User::varFileName] , 25, FINDSTRING( @[User::varFileName] , "\\", 4))

Not sure why excel is not saving your data exported to it. You may try this

1. Create a template excel file with you table (named range) in it

2. In your...

On the Flat File connection manager check the 'Column names in the first data row' checkbox. This will tell that you have column names in the first row. But if...

For using variables in SQL Task you need to use the Parameter mapping and map the variables. Depending on your connection type the parameter marker and parameter name would differ....

http://technet.microsoft.com/en-us/library/ms135952.aspx would be a good start.

I am sure you can find examples on the web too.

~Mukti

If you are using Data flow task and just using Oracle Source and SQL destination, the insert will fail becoz the task is trying to insert new records. As you...

Try setting the DelayValidation = True on Send Mail task.

Try

DATEPART( "dw", GETDATE() ) == 2 ? GETDATE() : DATEADD( "day", -( DATEPART( "dw", GETDATE() ) -2), GETDATE() )

Just added 2 days to return a...

Its actually trying to validate the ToLine thats the reason its showing the warning, if you set the DelayValidation property to true then it won't show the warning and the...

Try this

DATEPART( "dw", GETDATE() ) == 7 ? GETDATE() : DATEADD( "day", -( DATEPART( "dw", GETDATE() ) ), GETDATE() )

The above expression checks if today is...

One way if your CC and subject is stored in DB is to create variables eg vEmailCC and vEmailSubject both of string type and then create a Execute sql task...