Redirecting Output

SSIS Conditional Split Expressions

How to create an SSIS conditional data flow task

This article demonstrates how to selectively channel records from a flat-file data source to separate destination tables in an SSIS package using a combination of multicast, data-conversion and conditional-split data flow transformation elements within a data flow task.

RE: Query using view with outer join

It should work (in this case) if you use OUTER JOIN in the view. (I assume that join expression t1.emp_num = t2.emp_name is a typo and should be t1.emp_num = t2.emp_num)If view doesn't return too many rows you may use it as a derived table:select t1.sales, t2.emp_name from sales t1 left outer join (select emp_num, […]

RE: Preformance Tuning Advice

Thanks Ken and Arif I don't need to create indexes on the #tempTable so I will impliment the use of a table instead of a temporary table Definitely I will update the @returnVal = Null to IS NULL as well as creating the tables at the begining of the script to avoid mixing DDL and […]

RE: Jobs still run, even when DISABLED

Do you have any process wich runs them?Do you have any sp wich uses sp_Start_job?Check if any other job, runs them, or if you have any alert that executes them.

RE: How to ensure order is kept in import from csv

The behaviour is NOT guaranteed.  You need to understand what is meant by 'order' in a relational database, and how this interacts with a DTS load.The physical order in which rows exist has no relevance to the actual order rows are presented to the user in a SELECT statement.  There is 1 and only 1 […]