There's an identical thread by the same OP here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121061

You could use a script task for this. Go ahead and run your existing SSIS package to the the bad file (without blank lines), then create a new script...

I've had to do the same thing with some uncooperative vendors, and agree that traces are the best way to handle this. Triggers are an option, but can be...

One other thing to remember: Don't be discouraged if you don't master it overnight, because you won't. Nobody does. Have patience, stick with it, and know that you'll...

Although there's not really an all-inclusive guide, you can find a number of resources that can collectively help you to learn Transact-SQL.

As far as a book to start...

This is unlikely to make a huge difference, but try replacing your SELECT * with SELECT [column1, column2, ... columnN].

Are you running SSIS directly on the server, or are you...

A couple of things you can check. First, do you have the error output (red arrow) connected from the OleDB Source to the flat file, or the OleDB Destination...

I agree... Use a script task if you want to control the program flow based on the existence of a file, and force your script task to a status of...

I wouldn't recommend trying to access the last GUID entered, since they are nonsequential by nature. Can you post a sample of the source data?

That's where you'll use the Lookup Transform component to look up the GUID value for each row that is headed for your many-to-many table. Do the lookup so that...

Is your foreign key value a part of the data flow already? If so, there is no need to retrieve it from the primary key table - simply load...

Use 2 separate data flow tasks, one to load the primary key table and the other to load the M2M table with the foreign key. Use your precedence constraint...

Are you adding this directly to the MessageSource field? If so, the variables will not be evaluated but treated as literals. What you'll need to do is use...

Check the folder permissions - it sounds like you have "write" but not "modify" permissions granted to the SQL Agent account. This could keep you from modifying an existing...

When you dump the files to Excel, are you running the job manually, or is it being run as a scheduled job?