I see your first problem is that Express Edition will not allow you to connect to a SQL Server that is not local, ie: on the same machine as the...

You know there are a couple ways to do this.. I use a WMI Reader task to populate an object variable and then use a Script-Task as a Data...

You need a copy of that file in the location you are going to use it from. It HAS TO EXIST when you do your design work, also be...

Tunage, great way to drown out the assembled masses..

CEWII

I too agree with the editorial..

It is far too often WAY MORE damaging to jump into a fix without proper consideration than it is to stop and think about it.

Case...

You might look at the system variable InteractiveMode and look at this article:

http://jessicammoss.blogspot.com/2008/03/interactivemode-variable.html

CEWII

I agree with John. Also are there any row counts showing on the dataflow during the run or does it just go green..

CEWII

You've tried.. Ok, using what methods? I think we need a bit more detail..

CEWII

I have not seen anything for support for secure connections out of the box.

Although I haven't used it I hear CozyRoc.com has a component, you could also look on...

If I understand what you have done..

Here is what I think needs to be done.

1. Make sure the variable contains a value at design-time.

2. Set the connection to point at...

IF NOT EXISTS(SELECT ID FROM Table1 WHERE ID=2)

BEGIN

Insert Into Table2 ...

Insert Into Table3 ...

Insert Into...

Mike Voissem (3/12/2010)

---

The people running the SSIS will be users. I'm thinking that my best way for this is to create an agent job to run the SSIS, and...

How do you have login auditing configured? By default it only catches failed logins.. What traces do you have running?

CEWII

I believe that "Keep Identity" is effectively SET IDENTITY_INSERT for a table, which per books online:

User must own the object, or be a member of the sysadmin fixed server role,...

I just finished looking and there are effectively no options that can be set at run-time for the Fuzzy Lookup. Everything is set at design-time.

So I don't see a...