That's where I'd start. Add a System DSN named "WEB SQL" on the IIS server that hosts the IDC files.

If it's still not working after that posting...

Did you see a DSN named "WEB SQL" in the ODBC Administrator?

If it's there you'd open that up to change the server name.

In the .IDC file there is a setting named Datasource. That is an ODBC Data Source Name (DSN). The DSN contains the name of the database server. ...

Here's one way to include the output column name in the error file.

The overall process is to read in the SSIS package and create a collection of lineageId/Column name...

Setting a package variable in your Script Task sounds like the right track.

To use that variable open the properties for the Connection Manager used for the Excel file. Select...

Replacing the For Each loop with a For Next loop should work.

Dim usr as User

For x As Integer = db.Users.Count - 1 to 0 Step -1

usr = db.Users(x)

...

You can capture the errant rows to another file for review.

Edit the Flat File connection and change the Error Output behavior from Fail Component to Redirect row.

Next, drag a...

Checking if the table exists prior to the update or modifying the subquery are two options.

-- Option 1: Check for table before updating.

IF OBJECT_ID('mySchema.myTable','U') IS NOT NULL

BEGIN

-- UPDATE...

First, the variables would be specified as "a,b,c" (without the quotes).

Second, "Option Strict" is a compiler option that's there to help you from introducing logic errors.

For example, set the type...

There are at least three limitations that I'm aware by using the OLEDB Provider for Microsoft Directory Services.

1. It cannot read multi-valued attributes from AD, such as MemberOf.

2. It cannot...

The variables would added to the ReadWriteVariables option which is on the same tab where you clicked on Design Script... of the Script Task.

From that command it looks like the backup file is being appended to during each backup.

Two things to check are how large E:\Backups_Loc\db_name_db.BAK is in relation to that database...

That should be the same SID, different format. To convert that to a string like 'S-1-5-' here are a couple ways to do it.

Write a function to convert...

That sounds right. You define a file once when setting up the connection manager, then you define an Expression that will be used to replace the ConnectionString at runtime....

The BOL topic Getting Started with CLR Integration is a good place to begin. That will take you through editing, compiling and deploying a CLR stored procedure.

As far as...