Pam Abdulla - Thanks for the responce but it doesn't seem to work the same. Darren uses a table/view to table/view pump. I am doing a table/view to delimited...

Add the following code to your ActiveX Script.

With DTSGlobalVariables.Parent.Connections("[Put the Connection Name here]")

.Catalog = 'string value e.g. "pubs"

.Connection = 'boolean value e.g. true

.ConnectionImmediate = 'boolean value e.g. trueTrue

.ConnectionTimeOut =...

I'n not a big fan of using "LIKE". It slows down you queries when working wit hlarge amounts of data. This is what I would do:

CREATE Procedure select_Proc1

@Key3...

Sorry about the above sql formatting. But the site doesn't seem to allow indenting.

Hi guys,

I might be missing something here but shouldn't it be as easy as:

SELECT

[FIRST].A,

[FIRST].B,

[FIRST].C

FROM

YOUR_TABLE AS [FIRST]

WHERE

EXISTS (

...