It looks like your server requires authentication and the SMTP Connection Manager supports only anonymous or Windows authentication. Check if your server supports Windows Authentication and then enable this option...

Ignacio,

I have seen this before. And this is a tricky one. What is happening is that by default the SQL Job Agent is executing with your proxy account, using light-weight...

If you checked the post carefully you will see this scenario is possible. You have make sure you use the same connection object in the Execute SQL Task and the...

If you want to transfer your data securely I would advise that you setup FTPS or SFTP transfers. You can find SSIS components for it here. Setting up VPN is...

Handle OnError event and store if there is an error in a boolean package variable. Let's say TaskFailedVar. When your work flow arrives in your OnPostExecute logic, you will know...

Yes, it is possible. Check following blog post how to do it.

Here is what you have to do:

1. Pull the list of remote FTP files and store in package variable (check following script how to pull the list).

2. Insert ForEach container...

Check your system environment variables and set your TEMP folder to the drive where you would like to have it.

If you have a value that you need to store, create a class member and modify it during data flow execution. And then in your PostExecute method store the value.

Check PGP Task. It has very simple UI and great integration in SSIS.

Unfortunately there isn't support for stepping into script component. You can use the same old technique with message boxes to find out what is going on.

1. Setup flat file connection manager to the CSV file.

2. Insert data flow task.

3. Insert flat file source component.

4. Insert multicast component and connect to the source component.

5. Setup 2...

Jody,

Have you checked this thread?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2985964&SiteID=1

Fred,

Instead of creating DataSet object (which is not very useful in SSIS), you should create SSIS script source component and implement your web service calling logic in it. Then push...

Btw you may also check the EDI Source component. This format seems very similar to an EDI file.