I do something similar, mainly because I find using SQL to select the interesting parts of my log more natural than processing an unstructured text file.

I have a ToLOG(Level, Message)...

If by Control and App you mean control flow and data flow, I more or less do that. The file list is made and loaded into the FILELIST table...

Thanks! I'll put them into a script so I've got them ready next time it happens.

(I just tried it and got quite a list, but they all had blocking_session_id...

This function should find the matching files in a directory.

Public Function GetFiles(ByVal FileDir As String, ByVal FilePattern As String) As Long

' Process...

In your data flow component's Properties, try setting ValidateExternalMetadata to False. Does that fix the problem?

Firstly, what is wrong with NULL? If a cell has no value, and is empty or unknown, NULL is the correct representation of that.

If however you really do need...

Have a look at this, I think it will answer your questions:

http://blogs.msdn.com/b/mattm/archive/2006/11/08/stored-procedures-with-output-parameters.aspx[\url]

Just to add to what Raunak said - you can ONLY select the script language when you create a new Script Task; once you've clicked on Edit Script the language...

Are you running the stored procedure using an Execute SQL Task? If so, the way you pass values to the SQL procedure depends on your Connection Type. If...

Thanks. I'm about to read Part 2 (which was highlighted in today's email from SQLServerCentral).

I solved my problem after thinking about it more, and being inspired by Part 1 of...

I know this is an old question, but I found it via Google, and others might too, so here's some info for them.

If you want to defragment your indices as...

I had a similar problem, where I needed to output a number of reports as tab-separated text files; each was based on a view, and I wrote a script task...

I had a similar problem, where the package could be run on 3 different servers, which had different file layouts. I solved it by having a script task at...

This is news to me, so a very useful topic!

I thought SHRINKDATABASE was a good thing to do, because it reduces a large and useless transaction log file at the...

A better solution is to make the driver test more rows. E.g. use this connection string for your file, which I'm assuming is in a variable called File

ConnectString =...