On your connectionmanager, look at the expressions section.

Add an expression and change the connectionstring property to your variable.

TADA

~PD

Sure you can change the layout, else it would sorta defeat the purpose of development.

Double click on the connection manager and have a look at the advanced tab. There is...

uhmmmmm

Where to start...

First off, this is the SSIS forum, and you may get some skewed advice.

My 5 cents (and please dont anyone shoot me), but this is my perception at...

Not sure, readup in BOL in SSIS string expressions

~PD

Lemme get this straight...

You want to create an excel workbook with 162 sheets. hmmmm, I actually feel sorry for whoever is going to read this report.

Nonetheless, conceptually this should not...

Execute process task will allow you to execute a Win32 process

~PD

Derived column transformation will allow you to concat the remaining fields into a single field

~PD

Uhmmmm, I would consider using a derived column, and working with some string functions, and then building a concatenated date value from there (something like left, mid and right)

Trust this...

You would select firstname and lastname from your respective tables, and write a derived column which now becomes NAME.

Merge join is all about knowing if you want to do the...

I am not saying that you should hardcode anything.

All I am saying is that the same way you are building the SQL statement which you are passing to your variable,...

That is one of many ways in which you can do this. But I think you are missing the point....

Possible suggestion

a) Stage the data (have a staging database). In other...

How do you mean it is not going to merge the file?

Of course it will

Hey Sharon,

You are definitely on the right track. Use the concepts of this article.

Basically, your filename variable you will add to the expressions section of the flatfile connection in the...

If the table is not too big, I would create a table valued function where I specify everything as char(x), and then insert the data into here.

Wont this force the...

uhmmmmm

🙂 is not a very descriptive posting.

Readup in BOL or google, and if you get stuck, post a little more detail