Do all of the worksheets in all of the spreadsheets have the same column headings?

Tom

I don't think this is posted in the right forum.

Tom

Do a search on the interweb for SSIS event handlers and you will find all sorts of comments about how and when the events fire.

Possibly one way to get around...

Currently, there is no inbuilt update functionality within SSIS 2005 (I think there is something coming in SSIS 2008 to deal with this).

The only way is to write the new...

When you build your variable that holds the ftp path (or indeed, any directory path for that matter) you need to escape special characters of which "/" is one.

Simply replace...

I think in each case you could add a derived column called FLAG, or something like, which holds the information about each row whether it is VALID, INVALID or MISSING,...

I would have thought a SQL task would have been the best candidate for what you are looking to do. What were the errors you were receiving?

Could you not...

Not sure if this will work, but you can set the whole connection string to the ODBC in one go, so you could build it dynamically with dsn name, username,...

A couple of questions:

Does the account that is running the package have sufficient priviledges on the excel file?

If so, have you tried saving a copy and accessing the copy?

Tom

I'm not sure I quite follow exactly what it is you need to do, but the derived column transformation allows you to change column values (or add in new columns)...

Could you not use a data flow task with the excel file as the source and the csv file as the destination? It would be easier to debug where...

have a look at the post on the Jamie Thomson's blog, i think this covers the same sort of issue:

SSIS Junkie

Tom

Are the file locations hard coded into the package? If so, I think you can use a script task to access the connections programmatically, and from there pull the...

Please excuse me if I am stating the obvious, but are the ODBCs set up on the target server?

Tom

You could store each connection string in its own variable (SQLDev, SQLProd, etc). Have a variable to hold the user's choice of environment (SetEnv, maybe). Then, have a...