How to connect ExecuteSQLTask with data flow task

• qiuwei

  SSC Enthusiast

  Points: 131

  More actions

  March 8, 2007 at 4:27 am

  #116587

  Hi, there;

  I am doing my first SSIS project that moves data from dbf file to SQL2005.

  What I did here is that I created a dataflow task (move data)with ASP.NET successfully (Very happy!). Now I want to create an ExecuteSQLTask that runs before data flow runs. This ExecuteSQLTask is used used to create a table if there is no destination table in the SQL2005.

  This can be done easily in SSIS design mode, just need to connect those two box with a green line: )

  I had a look example from MS website, but I didn't find a code example to connect this two task.

  Does anybody know how to resolve this or have any link with sample code?

• S. Kusen

  SSChampion

  Points: 10936

  More actions

  March 8, 2007 at 2:24 pm

  #693938

  Hi,

  You can't single-click on the ExecuteSql task and then drag the green line to the Data Flow task?