Viewing 15 posts - 1,411 through 1,425 (of 3,232 total)
Please don't cross post.
Continue this thread here: http://www.sqlservercentral.com/Forums/Topic732456-147-1.aspx
June 10, 2009 at 10:53 am
Step 1: Execute SQL Step - SELECT Col1, Col2, Col3 FROM YourTable WHERE........
-- Result Set = Full Result Set
-- Result Set tab...
June 10, 2009 at 10:51 am
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...
June 9, 2009 at 3:22 pm
By the way, I tested the expression and it should work as-is.
June 8, 2009 at 4:00 pm
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
...
June 8, 2009 at 3:40 pm
You need to use the expression builder to set the arguements property to
"/c c:\practice_move_pdfs.bat " + @user::book
or something similar.
June 8, 2009 at 3:13 pm
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...
June 8, 2009 at 2:59 pm
Set the FileSpec property using the expression builder.
June 8, 2009 at 1:36 pm
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,...
June 4, 2009 at 12:30 pm
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...
June 4, 2009 at 12:26 pm
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...
June 4, 2009 at 9:14 am
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...
June 3, 2009 at 4:17 pm
Great article Scott. I love your approach. Just curious, what are you using for your Package Protection Level, server storage?
June 3, 2009 at 9:24 am
Wow....this one should make it to the 'evil' interview questions list.
May 20, 2009 at 9:17 pm
Viewing 15 posts - 1,411 through 1,425 (of 3,232 total)