How to dynamically get data from different source

• chatwithkrishan

  Ten Centuries

  Points: 1056

  More actions

  August 14, 2010 at 12:58 pm

  #226150

  Hi,

  How to Get data from Different Sources Dynamically (ie.., One week from Excel and another week from Text File)

  Thanks in advance

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  August 15, 2010 at 11:38 pm

  #1207155

  Krishna,

  Could you be more specific with your requirements?

  Raunak J

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  August 16, 2010 at 12:29 am

  #1207175

  You need a seperate data flow for each type of source. Even if you have 2 excel files but with different structure, you need 2 different dataflows. Then choose conditionally which dataflow to run.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• chatwithkrishan

  Ten Centuries

  Points: 1056

  More actions

  August 17, 2010 at 11:40 am

  #1208063

  I created 2 variable . one for File location and one for flag to determine for file extension.

  I wrote the following code in script task

  if (DTs.Variables['Filelocation"].value.ToString()).Contains (".txt"))

  DTs.Variables["isTxt"].value=True;

  else

  DTs.Variables["isTxt"].value=True;

  i created 2 Data flow tasks (txt and Xls)

  in the Precedence Constraints, i added expression @isTxt==True

  Its works fine.

  I just need to know is there any other best solution.

  Thanks in advance

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  August 18, 2010 at 12:45 am

  #1208321

  The solution you worked out seems fine to me.

  You only need to make sure that no other .txt or .xls file comes in with a different metadata structure, as it would cause the package to fail.

  You can also make it more robust:

  - what happens if a .csv file comes in?

  - you can add event handlers that clean up the files if there is an error

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP