DYNAMICALLY DATA CHANGING TO CLIENT REQIREMENT BASEDON REQUST FROM CLIENT

• brainblower13

  Right there with Babe

  Points: 719

  More actions

  August 12, 2010 at 12:18 am

  #146674

  IF 30 DAYS DATABASE ARE THERE . NOW I WANT TO BUILD PACKAGE FOR DATA RETRIEVAL BASED ON DATE . HOW I BUILD THE PACKAGE FOR DYNAMICALLY CHANGING DATA NEEDED AS PER CLIENT REQUIREMENT ? WHICH TASK I WILL USE ? HOW I WILL CONNECT THE CONNECTION MANAGER IN SCRIPT TASK ?

• brainblower13

  Right there with Babe

  Points: 719

  More actions

  August 12, 2010 at 2:16 am

  #1205844

  l

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  August 12, 2010 at 3:01 am

  #1205861

  It seems that your keyboard is broken: all your text is accidentally printed in caps.

  Google (or Bing) these simple keywords to find your answer:

  * SSIS tutorial

  * SSIS connection manager

  * Execute SQL task

  * variables and expressions in SSIS

  As far as I can deduce things from your question, I don't think you will be needing a script task.

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