Calling Ssis Experts....

[Darling999]

Konchem ikadiki randii oka package cheyyali ideas kaavali..

[mtkr]

hlp

[Darling999]

Nuvvu SSIS ey kada try cheyyi eminaa idea vastey..

hlp

 

Scenario:

 

1. I have 20 Temp Tables, all of them have a identical key field calles EMPID, but other fields are different.

2. all the above temp tables are derived from one different Joins.

3. after each temp table there is a delete statement (Some deletes are performed based on scenario) and Update statement(few fields are updated        based on scenario).

4. Once the Above operations are done, we movie all the data from all temp tables Into one Big Dimension Table using Union All in SQL.

5. this is all done in SQL store proc for now.

 

Requirement:

 

Now I need to convert this to a Native SSIS package using Components(Other than execute SQL tasks), to achieve the above.

So provide any inputs.

 

Thanks

 

 

[Silver_mani]

hmmmm

[Pandu_age40]

Nuvvu SSIS ey kada try cheyyi eminaa idea vastey..

Scenario:

1. I have 20 Temp Tables, all of them have a identical key field calles EMPID, but other fields are different.
2. all the above temp tables are derived from one different Joins.
3. after each temp table there is a delete statement (Some deletes are performed based on scenario) and Update statement(few fields are updated based on scenario).
4. Once the Above operations are done, we movie all the data from all temp tables Into one Big Dimension Table using Union All in SQL.
5. this is all done in SQL store proc for now.

Requirement:

Now I need to convert this to a Native SSIS package using Components(Other than execute SQL tasks), to achieve the above.
So provide any inputs.

Thanks

First query break vhesko and then execute sql lo query vaadiko... Global temp tables create vhesko and connections properties Loki poyi... Retain connection true undela chusko and final ga data oka staging temp table lo vachaka load into real table.... And make sure expressions and connection properties.

Ps: study the sql query well

[Darling999]

Execute SQl tasks lekundaa cheppu bhayya.. adey kada asking.. malli temos akkarlekundaa eminaa  solution untundaa ani.

First query break vhesko and then execute sql lo query vaadiko... Global temp tables create vhesko and connections properties Loki poyi... Retain connection true undela chusko and final ga data oka staging temp table lo vachaka load into real table.... And make sure expressions and connection properties.

Ps: study the sql query well

 

[SANANTONIO]

anni break cheskuni step by step rasko oka Stored proc lo....use physical tables instead temp tables..kavalante truncate chesko chivarlo.... make 2 stored procs and comibne them...final proceedure ni call chei....just edo idea....i am a java guy but works on Sql Server and Oracle both DBs..konchem idea undi...inkonchem clarity ivvu when you say "no sql task"..then i ask my colleagues

[sqladdict]

Execute SQl tasks lekundaa cheppu bhayya.. adey kada asking.. malli temos akkarlekundaa eminaa solution untundaa ani.

use script component as source and use linq for processing..enjoyy

[Darling999]

Already matter antha store procs loney undi bhayya.. they want to convert it to complete SSIS package with its components.. but Execute SQL tasks antey malli same procedure statements ni techy andulo run chestaam. Ala kakundaa SSIS components use chesi achieve cheyyachaa ani.

anni break cheskuni step by step rasko oka Stored proc lo....use physical tables instead temp tables..kavalante truncate chesko chivarlo.... make 2 stored procs and comibne them...final proceedure ni call chei....just edo idea....i am a java guy but works on Sql Server and Oracle both DBs..konchem idea undi...inkonchem clarity ivvu when you say "no sql task"..then i ask my colleagues

 

[mtkr]

:5_2_108:

[sqladdict]

Nenu ssis package loo excel ni script component too read chesta as source..ala cheyamni cheppadu naa mestri..vadi pichianandam

[sqladdict]

Already matter antha store procs loney undi bhayya.. they want to convert it to complete SSIS package with its components.. but Execute SQL tasks antey malli same procedure statements ni techy andulo run chestaam. Ala kakundaa SSIS components use chesi achieve cheyyachaa ani.

antey basic gaa processing antaa ssis server loo avvali..sql and sp ayitey sql server meda avvudi.adi mee meatriki istam ledu..adi matter

[sqladdict]

Already matter antha store procs loney undi bhayya.. they want to convert it to complete SSIS package with its components.. but Execute SQL tasks antey malli same procedure statements ni techy andulo run chestaam. Ala kakundaa SSIS components use chesi achieve cheyyachaa ani.

been there done that..hm

[SANANTONIO]

Already matter antha store procs loney undi bhayya.. they want to convert it to complete SSIS package with its components.. but Execute SQL tasks antey malli same procedure statements ni techy andulo run chestaam. Ala kakundaa SSIS components use chesi achieve cheyyachaa ani.

 

will check with SSIS experts here tomorrow

[Maga_Jathi_Vajram]

LTT