Set the ResultSet of the Execute SQL Task to full result set, then in the resultset tab, add a result set with Name = 0 and map it to a...

Not sure if you could use certificates directly in SSIS, but u can always use the Encryption and Decryption functions provided in SQL Server to use as execute SQL Tasks...

Read this article. I think u have a typical case from the article.

http://sqlscape.blogspot.com

For ppl reading this post: The problem was not the antivirus, it was the smtp server setting.

Open IIS, Right Click default SMTP server --> properties.

Click the "access tab" -->...

I figured it out. It was the anti-virus blocking my relays. Once this was down, my emails went thru.

Can u specifically isolate the rows (specifically the first specimen) that is causing the problem. I would say profile the data. use this one row in your load process (i...

Follow Arnar's post, and the post above it, they will solve the prob.

If u are using a proxy account to run the job, then give the credential (Windows AD account)...

Did u deploy your package to the right folder?

Open a connection to SSIS thru SQL Server Management studio and verify its path.

The error that u get is that the user who is trying to run the job does not have access to enumerate (view definition\execute) packages from msdb, or does not...

I agree with Jack, that is your best bet and also one of the best practices of loading data in an ETL environment.

name of the Maximum Errors property is "MaximumErrorCount"

I am not sure if this is a bug or intentional behavior in SSIS that any tasks placed in the Sequence Container report success even if they fail. Now,...

Configurations: Specifically the Parent Package Variable. I have created a metadata driven ETL to pass a configuration param of table schema name to packages.

U want to create a package similar to a method (in c#) and passing collections to it. There is an object data type in SSIS that can be used to...

Wht abt sending the error rows to a file and reviewing them?