[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

ssis execute sql task how to ?

In my dtsx packages. I have bulk insert task and execute sql task how do I link between this two ? and what option I have in execute sql task to save the query results to txt file and how to configure it ?
0
motioneye
Asked:
motioneye
2 Solutions
 
lozzamooreCommented:
You need to explain in a bit more detail what you mean by "link the two".

Generally tasks are "linked" to a "Connection". Once a connection is created, then the corresponding Connection property can be set in each of the Tasks.

As for results to txt file, if you are running a SQL query that produces results, then you would typically run this within a Data Flow task, and not a SQL Task.

Hope this helps,

L
0
 
Barry CunneyCommented:
Hi MotionEye,
To get query results to text file, the best approach is to drag an OLEDB Source object  and a Flat File  Destination object into the Control Flow section  in Designer.
Edit the OLEDB source to execute an SQL Command and enter the SQL statement that gets the required result set.
Edit the flat file destination and enter the path of the required text file
I have attached a print screen as an aid
SSIS.jpg
0
 
motioneyeAuthor Commented:
Thanks for the quick help :)
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now