July 30, 2012 at 11:37 pm
here i am having two database and i want to mapp the data related to that tables
July 31, 2012 at 12:14 am
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
August 3, 2012 at 12:07 am
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
August 3, 2012 at 12:25 am
sivag (8/3/2012)
in databse 1st databes A I AM HAVING A COLUMN ATABLE 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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 3, 2012 at 12:27 am
sorry
August 3, 2012 at 12:29 am
sivag (8/3/2012)
sorry
No problem. Take a look at the import and export wizard to get you started.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 3, 2012 at 12:38 am
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
August 3, 2012 at 12:47 am
plz give some idea about jobs in sqlserver
August 3, 2012 at 12:56 am
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
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 3, 2012 at 11:19 am
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
August 6, 2012 at 12:17 am
sivag (8/3/2012)
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
I think it's best you search the net a while for tutorials and SSIS books to get you started.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 7, 2012 at 5:09 am
If these are two databases on the same instance you can just run this to transfer data accross.
INSERT INTO DatabaseTarget..TableTarget (COL1, COL2)
SELECT COL1, COL2 FROM DatabaseSource..TableSource
That is the concept. There is more learning required to automate it.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply