Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS Newbie


SSIS Newbie

Author
Message
ThugCode
ThugCode
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 36
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
Steven Willis
Steven Willis
SSC-Addicted
SSC-Addicted (477 reputation)SSC-Addicted (477 reputation)SSC-Addicted (477 reputation)SSC-Addicted (477 reputation)SSC-Addicted (477 reputation)SSC-Addicted (477 reputation)SSC-Addicted (477 reputation)SSC-Addicted (477 reputation)

Group: General Forum Members
Points: 477 Visits: 1721
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.)

 
Attachments
SQL-TO_XL.pdf (24 views, 419.00 KB)
ThugCode
ThugCode
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 36
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.)

 

ThugCode
ThugCode
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 36
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!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search