September 10, 2014 at 8:23 am
I am new to SSIS 2008 Packages.
I have 3 different databases on same sql server which contains many tables.
Database A - Consists of 25 tables.
Database B - Consists of 30 tables.
Database C - Consists of 15 tables.
Some tables exists in all 3 databases but with different data. Also some tables exists in 2 databases (data could be same or different) and some exists only in 1 database.
I want to achieve the following tasks using SSIS 2008 package:
(1) I want to merge all the above 3 databases into one new database on the same sql server.
(2) I want to bring all the tables along with data from above 3 databases to the new database.I want to combine common tables into one along with data and move to the new database.
(3) Also I want to bring all the functions, stored procedures & views from all above 3 databases to the new database.
Please somebody help me in achieving above tasks. Also please suggest me what other things to keep in mind when creating a SSIS package.
Thanks in advance for any kind of help.[font="Arial"][/font]
September 11, 2014 at 12:42 am
miskeens (9/10/2014)
I am new to SSIS 2008 Packages.I have 3 different databases on same sql server which contains many tables.
Database A - Consists of 25 tables.
Database B - Consists of 30 tables.
Database C - Consists of 15 tables.
Some tables exists in all 3 databases but with different data. Also some tables exists in 2 databases (data could be same or different) and some exists only in 1 database.
I want to achieve the following tasks using SSIS 2008 package:
(1) I want to merge all the above 3 databases into one new database on the same sql server.
(2) I want to bring all the tables along with data from above 3 databases to the new database.I want to combine common tables into one along with data and move to the new database.
(3) Also I want to bring all the functions, stored procedures & views from all above 3 databases to the new database.
Please somebody help me in achieving above tasks. Also please suggest me what other things to keep in mind when creating a SSIS package.
Thanks in advance for any kind of help.[font="Arial"][/font]
Is this a one-off merge or something you will have to run periodically?
If it's just a one-off, what made you choose SSIS rather than one or more SQL scripts?
September 11, 2014 at 8:17 am
This will be one-off merge.
I thought it will be a good task to learn SSIS.
Can you please guide me with the sql scripts?
Thanks!
September 11, 2014 at 9:28 am
miskeens (9/11/2014)
This will be one-off merge.I thought it will be a good task to learn SSIS.
Can you please guide me with the sql scripts?
Thanks!
I think you might be better off using SSIS to do something far simpler (copying data from one table to another or out to/in from a flat file, for example) rather than for a complex project such as what you've outlined.
Have a look at the 'Stairway to Integration Services' series of articles on the SQLServerCentral.com site.
Regards
Lempster
September 11, 2014 at 1:45 pm
I changed my mind to accomplish my tasks using sql scripts instead of creating a SSIS package.
Therefore I created this post in a forum (i.e.SQL Server 2008 » SQL Server Newbies) for help with sql scripts.
Sorry for any inconvenience.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply