try this from Brad Shulz http://bradsruminations.blogspot.com/2011/01/so-you-want-to-read-csv-files-huh.html

it may do what you need

• This reply was modified 5 years, 6 months ago by frederico_fonseca.

you can use the one you desire.

and you need to change "-t7z" to be...

this is what I do in some (old) packages

note that the "add to zip " does not delete the files - on newer versions you would need to add "-sdel"...

you automate it in a similar way to winzip (assuming you were using the command line interface and not the c# dll)

I'll dig some of my examples and post here

Thanks Frederico. So you agree that CDC is similar to SQL Server transactional replication? Since setting up SQL Server replication also requires all tables to have primary key. You...

• This reply was modified 5 years, 6 months ago by frederico_fonseca.

Thanks! Has anyone has any thoughts on Change Data Capture.  The CDC function is, probably similar to the transactional replication.  It is not the same, but it has this...

• This reply was modified 5 years, 6 months ago by frederico_fonseca.
• This reply was modified 5 years, 6 months ago by frederico_fonseca.

few questions.

• what is the size of db - logs and data sizes separate
• is IFI enabled on the server
• was compression enabled on the backup (it should have)
• how...

and I've just noticed - the view code above does not correspond to the one that the explain plan is referring to.

JD.vw_Orders is the view used on the explain plan...

according to the plan it was called with

Parameter Compiled Value Runtime Value

[@ONum] '31856258' '31856258'

downloading the plan from the link does have all the info as far as I can see, including predicates.

and from what I can see it is only the view that...

or she would create a new account and...

and this is a lot easier to do in Powershell - which could be called from SSIS directly if "boss" insists in SSIS

variables could be passed from ssis or from...

As Phil said it seems correct.

so in order to test it to ensure that the 2 queries work the same way test the individual selects in isolation of the proc...

what attempts have you made so far?

that is a fairly simple case of replacing with a combination of "and" and "or"

no real good reason then to refuse to host it on that...