You can insert the rows from the table that contains the SSIS packages (the name escapes me for the moment. I guess dbo.dtspackages) and insert it into the correct table...

Apparently the reference data contains some duplicate values, so you'll need to clean that up a bit.

You can start here:

http://msdn.microsoft.com/en-us/library/ms169917.aspx

Allright, glad you found the issue 😀

Nice question, but I got it wrong by the ambigous column name (not really the point the question was focusing on).

You can use Visual Basic inside BIDS, you don't need a full version of Visual Studio.

In the dataflow, you can select the Script Component, which launches a shell of Visual...

Here you go:

http://dougbert.com/blogs/dougbert/archive/2008/05/10/adding-the-error-column-name-to-an-error-output.aspx

If you can execute a perl script with some sort of executable (I don't know anything about Perl), then you can use the Execute Process Task.

Going forth on your vague description, I guess you are working with an Excel file.

Is it possible to post at least the connection string itself here?

How do you write the logfiles?

Do you use a logging provider that logs events?

How do you make the connection to the database?

Are you sure you created the sp in the correct database?

Nice article, but the link to the sister article doesn't work.

Interesting question, thanks.

Easy one, thanks.

SQLkiwi (8/31/2011)

Agreed, but I had...