August 8, 2011 at 3:29 pm
I have 2 databases in different sql servers. One is my source database with plain tables(staging), other is my destination database with relational tables. I need to create a package for migrating data from plain tables into relational tables. I will present you one of my issue i am facing.
Plain table (Source): Address
col1: LocationName
Col2: City
Col3: State
Col4: OfficeType
Relational Tables(Destination):
Locations
Col1: LocationID
Col2: LocationName
Col3: LocationCity
Col4: LocationState
OfficeTypes:
Col1: OfficeTypeID
Col2: OfficeTypeName
LocationXOfficeTypes:
Col1:LocationXOfficeTypeID
Col2:LocationID
Col3:OfficeTypeID
I need to take the data from the source tables and populate 3 destination tables. This is very similar scenario in Normalized databases. I need to insert Unique Locations into Locations table and Unique OfficeTypes into OfficeTypes Table. And finally need to populate LocationsXOfficeTypes table with the ID's of Locations and OfficeTypes tables.
August 8, 2011 at 3:35 pm
Where are you getting stuck?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 8, 2011 at 4:00 pm
I am stuck in popluating the Join Table "LocationsXOfficeTypes". Need to get those unique ID's and populate relatively.
August 8, 2011 at 4:04 pm
But you are able to populate the other two tables?
Are you using a sql query in your SSIS package to determine the population of these tables?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 8, 2011 at 4:24 pm
I didnot started creating package (Analyzing Stage). I think we can use 2 OLEDB command transformations (sql queries with distinct clause) in populating Locations and OfficeTypes. But how about LocationsXOfficeTypes? I am not good in SSIS
August 8, 2011 at 4:26 pm
Repeated question. Please see discussion here: http://www.sqlservercentral.com/Forums/Topic1154726-391-1.aspx
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 8, 2011 at 4:32 pm
That question was posted by me. I didn't got correct answer over there. There is no seperate forum for SSIS 2008, for that reason I posted in 'SQLserver 2008 general forum' and here.
August 8, 2011 at 4:44 pm
Thanks Kraig
August 8, 2011 at 4:52 pm
kishoremania (8/8/2011)
That question was posted by me. I didn't got correct answer over there. There is no seperate forum for SSIS 2008, for that reason I posted in 'SQLserver 2008 general forum' and here.
In the future, if you feel the need to crosspost to try to garner more attention from people who only read one or two of the forum areas, post it with a brief description and an immediate link to the original post.
This does two things. 1) It makes sure that all of the discussion on a particular issue happens in one place, so that other people who are either reading it to solve their own issue later or are trying to help don't duplicate work and 2) Doesn't annoy those of us who are trying to help by making us try to keep up with 2-3 separate threads on the same exact subject.
You probably won't get the correct answer the first, second, or even third time. Your information was rather generic and we're trying to work through the details of what you need. These things take time, have patience, we're volunteers, not employees.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply