You've posted this to a SQL Server 2000 forum so you'll be limited to SCOPE_IDENTITY(). If this were SQL Server 2005 or up, you could (and should due to...

Happy to help.

Please don't cross post.

Continue this thread here: http://www.sqlservercentral.com/Forums/Topic732456-147-1.aspx

Step 1: Execute SQL Step - SELECT Col1, Col2, Col3 FROM YourTable WHERE........

-- Result Set = Full Result Set

-- Result Set tab...

Yes, if the file name does not meet the criteria for continued execution through the control flow, it will just proceed with the next iteration of the for each file...

By the way, I tested the expression and it should work as-is.

I'm with you. So here's how I see this comming together in terms of tasks/steps.

1. Set up For Each container.

-- use Foreach File Enumerator

...

You need to use the expression builder to set the arguements property to

"/c c:\practice_move_pdfs.bat " + @user::book

or something similar.

After looking at this a bit closer, it appears that there is a limitation to what you can define the FileSpec property to be as the expresssion is not evaluated...

Set the FileSpec property using the expression builder.

SQL Server will not allow you to use the TRUANCATE TABLE command on a table referenced by a foreign key. You have 2 options.

1. Drop foreign key, truncate table,...

First, take the data modeler out back and beat him with a rubber hose. We're dealing with relational data here, right? That is what a RDBMS is used...

Just a note to add. If you have an index on Date, Lynn's query would be the preferred method as it should result in an index seek. The...

I think you'll need to provide a bit more information before anyone can help you. Working with dates is pretty straight forward with SQL, but we need to know...

Great article Scott. I love your approach. Just curious, what are you using for your Package Protection Level, server storage?