Jeff,

That's a good idea, I could simulate the integrity and referential rules through a query and flag the rows.

Thanks - Tom

the problem with that is the xml configs don't use a connection manager.

The whole idea here is that a single connection manager would control access to the configs.

I'm not...

No your not but nobody talks about it much.

I had the same problem. I referenced Project Real and made my own system off of that design.

Works pretty good, but...

Thanks, That's what I decided to do.

It would be nice if I could make better use of the error handling, logging, and auditing that we've already buillt into SSIS and...

you could set delay validation to True for the excel connection manager.

r

I'm guessing you have a for each loop that is setup as "Foreach File Enumerator"

If not create one.

Add a variable (v1) for storing the original name

Add a variable (v2) for...

Sorry,

I have a staging table and the production table. I use a conditional split after a merge join (left outer) to determine if the row exists in the destination (or...

What we have done is setup the data flow to use a generic name like DataSouce.xls.

You actually need a file by that name to get the data flow setup, after...

Why not put actually put the column names in the first row of data.

Setup your query to get the column names from the schema view then union that single row...

Put a script component in your event handler and reference these system variables as read only:

ErrorDescription,ErrorCode,SourceName

Enter some of your own variable as read/write

separate all variables with a comma on the...

This sounds like a job for a stored procedure, you could cursor through the list of databases that need a table and build the tables by creating a dynamic SQL...

You can use an execute sql task that return the results of a sql query.

Store the results in a variable of type Object.

Use a for each loop and...

My first thought is to build this as a stored procedure and just call it for the execute sql task.

You can use and ADO.NET connection type and set up the...

my guess it that it exists in the data but just not displayed in Mgnt studio results.

If you open the table not query it you should see those characters.

Other thing...