May 1, 2013 at 1:52 pm
I was recently assigned a SSIS project for a client.
The requirements are;
Load data from 6 database tables into one excel sheet, while creating 4 new tabs for the new table data coming in. This excel sheet already has tabs for 2 tables, that's why only 4 more new tabs need to be created.
The database tables get updated on a nightly basis so the new data needs to be inserted into the excel sheet. This would also need to be automated, the client would have the updated data every morning when he opens the excel sheet.
Can someone please guide me in the right direction? I haven't used SSIS to an extent like this before.
More information can be provided if need be.
Thank you
May 1, 2013 at 5:53 pm
syadnan2408 (5/1/2013)
I was recently assigned a SSIS project for a client.The requirements are;
Load data from 6 database tables into one excel sheet, while creating 4 new tabs for the new table data coming in. This excel sheet already has tabs for 2 tables, that's why only 4 more new tabs need to be created.
The database tables get updated on a nightly basis so the new data needs to be inserted into the excel sheet. This would also need to be automated, the client would have the updated data every morning when he opens the excel sheet.
Can someone please guide me in the right direction? I haven't used SSIS to an extent like this before.
More information can be provided if need be.
Thank you
I've created a simple SSIS SQL-to-XL project and screen captured the results of each step in the attached PDF. This should get you started. (BTW, my version is 2008 so other versions may be slightly different.)
May 1, 2013 at 6:01 pm
Thank you, I really appreciate the help.
Steven Willis (5/1/2013)
syadnan2408 (5/1/2013)
I was recently assigned a SSIS project for a client.The requirements are;
Load data from 6 database tables into one excel sheet, while creating 4 new tabs for the new table data coming in. This excel sheet already has tabs for 2 tables, that's why only 4 more new tabs need to be created.
The database tables get updated on a nightly basis so the new data needs to be inserted into the excel sheet. This would also need to be automated, the client would have the updated data every morning when he opens the excel sheet.
Can someone please guide me in the right direction? I haven't used SSIS to an extent like this before.
More information can be provided if need be.
Thank you
I've created a simple SSIS SQL-to-XL project and screen captured the results of each step in the attached PDF. This should get you started. (BTW, my version is 2008 so other versions may be slightly different.)
May 2, 2013 at 8:52 am
I've created most of the SSIS package but I'm having trouble with creating a variable.
The variable is for TableName. In the data flow I have an OLE DB Source, Data Conversion and Excel Destination. Now for the OLE DB Source, the data access mode I was going to use was SQL Command with Variable. I can't seem to create a SQL statement within my TableName variable to dynamically select tables from my database. I need to import data from 6 different tables from the same database.
How would I go about completing this?
Any suggestions would help!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply