so you mean your destination is excel file again?

Okay, I have tried it and it is working fine. Here is what you are supposed to do.

In Data flow:

First, drag and drop the excel source transformation and plug in...

Also, you should have noted that SSIS have different kind of datatype namings. Be assure that you are using the right type by checking all your datatype here

If what you want to do overall is nothing complicated and you know which key to use to delete the row, then just use the execute SQL task transformation to...

Try using Derieve column transformation.

Try using OLE DB source>>Union ALL>>OLE DB Destination

*OLE DB Source will contain ALL your Database tables that you want to bring in

Ok, Let me get it right. You are just trying to feed a table from a flat file right? If so, just do a simple package by having flat file...

From reviewing the errors and also the files you have sent, it is clearly something is wrong somewhere in either the stored Procedure itself or the way you call it...

Hi, I tried it my self with the chunk of info you had in the file you uploaded here. It worked for me. All I did was from flat file...

Dude!!that's totally crazy to be having that many columns in a row!!. Did you check if you have exceeded the amount allowed? you have to compare that with the bytes...

Click Here. It's pretty easy. You can do it in less than an hour.

Correct me if I am wrong. You have 992 columns coming in from a flat file?

Basically you have to use FTP task transformation mainly, plus a file system task to pull the .bak files to the FTP site. That's all.

1. If you know how...

Hi, actually, that someone who has the priviledge can also email the .bak file to you. Then you can do the same thing.

The address that I am talking about here...

The second method is actually cool! Okay, here is how it goes. Do you have access to some share drive? If so, ask someone(preferably someone with authentication), to backup the...