Parameter mappings should work for this.

On the general tab of the Execute SQL Task editor set the SQLStatement to: select * from MyTable where id = ?

Then go to the...

Right click on the connection manager and select Edit. The Flat File Connection Manager Editor will open, then select Advanced in the left hand pane. This will list the columns...

It would be very difficult to branch and merge SSIS packages. Even cosmetic changes like moving tasks on the control flow will cause the XML to change and that makes...

I would not suggest using disabled tasks to store comments. You can use multiple annotations in the control flow and data flow. You can put one next to each task...

Mike,

Are you ultimately trying to find the members of windows groups that have logins on your servers?

If so you can use xp_logininfo

EXEC xp_logininfo

'TheWindowsGroupYouWantToKnowAbout' -- account_name

,'members' -- [all|members], show members...

You can use a case expression:

SELECT

SomeCol

,WhatItIs

,CASE WHEN LEN(SomeCol) = 0 THEN '#' ELSE SomeCol END AllSpacesToPound

,CASE WHEN DATALENGTH(SomeCol) = 0 THEN '#' ELSE SomeCol END EmptyStringToPound

,CASE WHEN SomeCol...

When you are looking at the SSMS grid nulls and cells with whitespace are not the same thing. In fact cells that look like white space or empty strings can...

You should be able to do this with a lookup and a derived column (see attached screenshot).

Send the file output into a lookup task and join File.Ref on SQLTable.RefB just...

I think option 1 will serve you best but here is some info on how you could do option 2.

Setting this up is not difficult but when an ownership...

Can you post some more detail on the file and table structure plus a few rows of sample data as well as the desired result?

Jeff has a good point with option 2.

Option 1:

Pros: No cross database dependencies

Cons: Potential to give users too much/too little access (could have permission on a table, might not have...

I would use option 1. I don’t know that option 2 would really offer you any benefits and there are just a few more details to implement and maintain.

You could...

The unique constraint violation might be caused by nulls in your join columns. There are probably rows with a null Address2 line that might already exist in addresses and when...

You might be better off using an identity column for PlanID. While the order would not be sequential for each SessionID it would be increasing and it would make the...

Thanks Jeff.

Glad I didn’t get hit by any flying pork chops. 😀