Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • 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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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