WHOA!!!! I wanted to reduce font

Eishhhhh, sorry everyone

:blush:

Delete Statement in more readable format:

DELETE CSInquiry_Test.dbo.InquiryHeader WHERE Inquiry_Number in (

Select Test_ESS.Inquiry_Number

FROM T5_Reporting_FSUser.Test_ESS Test_ESS Left Join dbo.SiteInfoForm ON Test_ESS.ESS_Site_ID = dbo.SiteInfoForm.Cust_ID

Where Test_ESS.ESS_LNDtTimestamp...

Inside the dataflow you will have the rowcount which will update the variable.

Inside the controlflow you will specify not to run if the rowcount variable is equal to zero

I just started using tabledifference yesterday, and it rocks all the way...

Just watch out for sorting your data and trimming, and case sensitivity.

Didnt get time to test the Syncflow though...

~PD

If you click on the file itself, you will notice a red arrow. This is the data that will be redirected that fails to import.

On the error output section of...

So on your table you have daterange as a field?

Or how is the data structured on your table

Why use a scripting task at all?

I dont understand?

You have an an excel source with connectionstring, and OLEDB destination with connectionstring, which in all likelihood contains a catalog.

Your OLEDB destination...

Andrew,

I know you are saying that it hangs before it starts, but from your log it shows that it started...

Maybe you should consider package logging, and have a look at...

I am with Michael on Merge Joins, they outperform Lookups if handled correctly.

A little footnote on this, what you may want to do is delay the join slightly to avoid...

Now you have me confused.

You want to use that range in a SQL statement?

Why not have a datefrom and dateto variable (date)

Then you can specify where date >= datefrom and...

I had a very interesting one yesterday where TRIM bit me comparratively hard.

Was doing the tabledifference component for the first time (seriously rocks man), and kept on getting adverse nonsensical...

No need to set the connectionstring in code....

Why not use package configurations?

They will allow you to set the connectionstring dynamically and add the required portability to your error logging...

I am with Crever on this one, normally a rights issue

~PD

Do you have package logging enabled?

This will allow you to at least see where in the process it is failing.

I would also take a Friday night off of drinking and...

In SSIS there is a rowcount transformation, which will update a variable with the count of a particular data stream.

I would go for that, and add an expression

~PD

Hey,

I am assuming you come from a DTS background where you could dynamically set the source, destination and transformation pipes.

Bad news is, this aint possible in SSIS. You will have...