Data migration with SSIS

Question

Data migration with SSIS

Viewing 8 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281344 More actions · Answer 1

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

kishoremania Ten Centuries Points: 1059 More actions · Answer 2

I am stuck in popluating the Join Table "LocationsXOfficeTypes". Need to get those unique ID's and populate relatively.

SQLRNNR SSC Guru Points: 281344 More actions · Answer 3

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

kishoremania Ten Centuries Points: 1059 More actions · Answer 4

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

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 5

Repeated question. Please see discussion here: http://www.sqlservercentral.com/Forums/Topic1154726-391-1.aspx

- Craig Farrell

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

kishoremania Ten Centuries Points: 1059 More actions · Answer 6

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.

kishoremania Ten Centuries Points: 1059 More actions · Answer 7

kishoremania

Ten Centuries

Points: 1059

August 8, 2011 at 4:44 pm

#1365591

Thanks Kraig

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 8

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.

- Craig Farrell

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