Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

can any one plz give some idea about SQL Server Integration Services (SSIS)? Expand / Collapse
Author
Message
Posted Monday, July 30, 2012 11:37 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 06, 2014 1:47 PM
Points: 211, Visits: 1,369
here i am having two database and i want to mapp the data related to that tables
Post #1337675
Posted Tuesday, July 31, 2012 12:14 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 23, 2013 12:51 AM
Points: 56, Visits: 53
I think you should explain your setup a little bit more if you want an answer that you can use.

If I understand you correct, then you have two databases A and B and in them there are some tables Tbl1, Tbl2, Tbl3. They should be syncronized?

SUGGESTION 1:
You could use replication instead of SSIS, and depending on a lot of factors you should choose between Snapshot, Transactional or merge replication.

SUGGESTION 2:
If you want to you SSIS, then a very easy way is to add two task to your controlflow:

1) A SQL Task
2) A data flow task

Before you do that, then you should add a connection to Database A and Database B.

The SQL Task could empty all rows in the destination table.

The dataflow task you add a source --> Choose the table in the source --> add a destination and drag the line between source and destination.. Do some minor setup in the destination and it is running.

SUGGESTION 3:
Also use SSIS, but only have a data flow task, where you have a source and then you choose the transformation Slowly changing dimensions and configure that.

BUT BUT BUT!! THere are many other ways to do it, and it really depends on what you want to achieve.

Soren


Post #1337681
Posted Friday, August 03, 2012 12:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 06, 2014 1:47 PM
Points: 211, Visits: 1,369
in databse 1st databes A I AM HAVING A COLUMN A
TABLE 1 SER1
WHICH IS HAVING COLUMN S LIKE COL1,COLS2 ,COL3


FROM THIS TABLE I WANT TO TRANSFER DATA OF COLS2 TO 2ND DATABASE

TABLE 1 SERT
WHICH IS HAVING COLUMN S LIKE COLL1,COLS2 ,COLL3

HOW TO CREATE JOB FOR THIS
Post #1339637
Posted Friday, August 03, 2012 12:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
sivag (8/3/2012)
in databse 1st databes A I AM HAVING A COLUMN A
TABLE 1 SER1
WHICH IS HAVING COLUMN S LIKE COL1,COLS2 ,COL3


FROM THIS TABLE I WANT TO TRANSFER DATA OF COLS2 TO 2ND DATABASE

TABLE 1 SERT
WHICH IS HAVING COLUMN S LIKE COLL1,COLS2 ,COLL3

HOW TO CREATE JOB FOR THIS


Typing in caps is like shouting. Nobody likes that.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1339642
Posted Friday, August 03, 2012 12:27 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 06, 2014 1:47 PM
Points: 211, Visits: 1,369
sorry
Post #1339643
Posted Friday, August 03, 2012 12:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
sivag (8/3/2012)
sorry


No problem. Take a look at the import and export wizard to get you started.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1339644
Posted Friday, August 03, 2012 12:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 06, 2014 1:47 PM
Points: 211, Visits: 1,369
ya i just tried that import data and export data plz tell how to tranfer datas in database a table 1 column

cols2 to database b table 1 column cols2 one by one data using jobs in sqlserver
Post #1339651
Posted Friday, August 03, 2012 12:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 06, 2014 1:47 PM
Points: 211, Visits: 1,369
plz give some idea about jobs in sqlserver
Post #1339652
Posted Friday, August 03, 2012 12:56 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
When you run the import export wizard, you have the option at the end to save the package. Do that.
Then follow these steps:

SQL Server Agent Jobs for Packages




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1339656
Posted Friday, August 03, 2012 11:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 06, 2014 1:47 PM
Points: 211, Visits: 1,369
here i just opened job and i made a right click the i found new job i just selected that than after that how i can call the source data can any one just tell me
Post #1339999
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse