I don't have these DLLs

Did you install something else?

Like some SDK?

I must admit, I am tempted to have my own logging beside that of SSIS DB, precisely for the reasons you mention.

Yes, I would most probably start the procedure with a Execute SQL Task, passing something identifying the execution of the package (for instance the SSIS Db execution_id if I could...

I am indeed using SQL Server Developer edition 64 bits and I do get through once I have created a 32 bits alias.

I did not realise that the 32 or...

Phil,

One more question if I may...

I can get this Alias to work when I connect through ODBC (like through MS Access or an ODBC connection through an SSIS Package) but...

I like the idea of the Alias... Do you do that through .../Windows/system32/drivers/etc/hosts file?

For SSISDB, do you just not define it in your dev environment, or get it pointing at...

Phil,

In previous versions, I found that SSIS was...

Aaron,

If I am right, you can let Visual Studio do this for you.

When you add a solution to TFS, it should take care of all this for you.

Eric

Because the table was pretty big and I was not allowed any downtime...

...Plus I did not think about this at the time! 😀

Funny you would say that, this is exactly what I tried yesterday...

I was working on an IIS Log file and reading the file looked very quick so I adopted that...

Yes... but I am trying to avoid putting my (Fact) table in a staging table so I would like to drop the rows straight into the destination, therefore I need...

Wonderful!

Thanks

Sorry everyone: wrong forum!

I'll re-ask in the Analysis Services forum... :ermm:

Scott,

Thanks for that. It's really interesting and I will certainly "pinch" the idea for some project but it may not answer exactly my current problem.

The documentation I am looking for...

Could Master Data Management help?

I know that's not really the main purpose of that tool but isn't there a documentation aspect to it?