Is your environment such that you can try to run the package with the same account you used in testing? That should tell you if the problem is with...

You can use the FTP Task in SSIS to download the file from the server to your SSIS server.

To unzip the file, you'll need an archive tool that supports command...

Sai,

You should have the 32-bit dtexec executable file on your server [under the Program Files (x86) folder] which would allow you to utilize the Excel connection on the 64 bit...

I've got a video on SQLShare.com (formerly JumpstartTV) to demonstrate how to process SFTP files in SSIS using freeware components. You can watch the video here.

Jeff,

I suspect that your problem is the Package Protection Level setting. By default this is set to SaveSensitiveWithUserKey, which works great until you deploy the package or try to...

You're right, this is an interesting scenario to think about. After reading the OP's description and subsequent clarification, I've started writing an article to address a situation such as...

Yes, and It Depends 🙂

Using a ForEach loop with a parameterized SQL query would require multiple trips to the database. It depends on the size of the data and...

If there is a predictable pattern to the data within the header record, you could use a conditional split transformation and send those header rows to an alternate location.

hth,

Tim

If you're using SQL Server 64 bit, there is no Excel driver for that version - you'll have to use the 32 bit version. See a similar discussion here.

However,...

Greg,

If you're sending the rows to different outputs, would it make a difference if all of the C values are processed before the B values? You might do some...

You could use a ForEach loop, and create an expression to dynamically set the filename for each iteration of the loop. Set it up using the For Each Item...

You might consider using a Sort Transform for each output of your Conditional Split. You could sort by the DateTime column to guarantee order of insertion into your destination.

hth,

Tim

A couple of different approaches. You could modify your query on the [TableA] to [TableB] load so that duplicates do not exist in the first place. This is...

Did you have a specific question about any of these tasks? You can certainly use SSIS to accomplish what you describe.

Instead of doing it for you, I'll walk you through it so you'll be able to do it yourself next time 🙂

The component you want to use is the Conditional...