ronan.healy (8/12/2014)
how if im using an sql script
Nothing was said about using a SQL Script (exeucte sql component). Your data source (ole db source) can use a sql statement/query as the source instead of a full table load.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events