OK, just tried this with my own system:

"select f1, f2 from account where accountid = '" + @[User::AccountID] + "'"

is the value of SqlStatementSource, under Expressions.

Did you try using the 'Expressions' property as I suggested? Otherwise your statement will not get evaluated ...

You will be able to paste your variable into your SQL statement using...

roundel1900 (8/11/2009)

---

Maybe I am not explaining this correctly. Yes it appends the rows but without regards to the keys. So as it stands now I can continually append the exact...

Did not! 🙂 'This' is a hyperlink in my post. Happy hunting.

It is likely that you can use an Expression to set the SQLStatementSource property to get what you want, without the need for all the faffing around you mention in...

Not easy. You'll probably need to get hold of the Excel object model and manipulate the spreadsheet via a Script task before and after the updates to get anywhere with...

Appending rows is the default behaviour. Any other requirement (UPDATE or replace, for example) would require additional steps.

Unless you are prepared to take the time to provide a few more...

All you need to do is update the meta data for the source connection to include the extra columns - but you don't need to send them through the pipeline....

The reference to 'long' data made me wonder whether it is, for some reason, expecting a long integer rather than a string. But based on what you have written, this...

Inelegant as it may seem, your fastest solution is to create 18 'hard-coded' data flows.

I know, I wouldn't like it either :w00t:

An alternative is to build the whole thing in...

I suggest that you read and follow this thread - it's relevant to what you are trying to achieve:

http://www.sqlservercentral.com/Forums/Topic764541-148-1.aspx

Try using & instead of + ...

The TRUNCATE option will work, but do you really want to delete everything from the table every time before you perform the import? Or maybe you want to import 'new'...

If you check the meta data for the OLEDB source in your SSIS package, for both External data and Output data, what is the datatype of the column which is...

By 'fails', do you mean that zero records are retrieved?

There is probably a way of achieving this by using a conditional split based on record count (0 is one path,...