You could put a T-SQL task before it that has a SQL statement something like:

IF EXISTS(SELECT MyValue FROM MyVariables WHERE MyVarName='NORUNTASK1' AND MyValue = 0)

RAISERROR('Do Not Run',16,9)

Then,...

There are many reasons to manage these values. For instance, if you have millions of rows being loaded by your ETL process, the time to commit everything in a...

That sounds pretty reasonable to me, but testing is important and you should do what you can. I assume you can figure out the number of processed records (bills,...

Always consider the source.

I readily admit that I am an idiot and a poor judge of character.

I do want to say that the new site is very nice and everything works well. It has just been a bit slow - frustratingly so yesterday.

Assuming you have a SQL statement that returns one column and one row like:

SELECT GETDATE() AS MyDate

1) Go to the control flow tab

2) Create your variable

3) Create an executeSQL task

4)...

Yesterday, when I was posting this thread, it timed out on me several times. Today, it seems ok.

I am on a corporate network with dual T1 connections. I...

That is awfully nice of you to care what happens after you leave.

Nobody owns an SSIS package. You may own Agent Jobs that run them. If you saves...

This must be one of those new sideways databases in which there is a single record with each piece of data in it's own column.

Sorry Pam

Jeff has a really good...

Without writing your own assembly, you could create a Credential for the SQL windows login and then try to access a network resource with it. If the username, password,...

You don't need to cross-post on these forums, we will find it.

RS performance is in a couple of pieces, the actual query being run and the the rendering of the...

Full Sun (www.Fullsun.com) has a free log reader tool that will help if you have a transaction log.

Normally I would say you get what you pay for, but in this...

My first suggestion would be to run some tests. Set u[p your configuration to a server that is on-site and monitor the bandwidth used for a week.

You will have...

I agree with Matt, the optimizer is going to give you the same execution plan regardless of where you put this piece of criteria.

Putting it near the join for the...

You would do this type of logic in a precedence constraint in an SSIS package.

Go to your Control Flow tab.

Create another ExecuteSQL task and a variable. Execute your query...