Execute SQL Task

Question

Execute SQL Task

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

Nope, using 2008.

Date stamp is built using date parts with GetDate() as the source.

Then date stamp variable is then used in another variable to build the SQL statements. Very simple statements, not very long. See the first page of the thread for some more expression details.

Todd McDermid Default port Points: 1416 More actions · Answer 2

That's too bad - I thought they'd squashed that bug in 2008.

Try one of the other two workarounds - like collapsing the "depth" of the expressions, or using a Script Task to eval them.

Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components

nairdeepa Ten Centuries Points: 1296 More actions · Answer 3

Hi,

Just curious to know before you did 'execute sql task' how did you provide the source that provides the data into sql task? My problem is similar to urs, and i dont have a clue on mine

thanks for ur help!

debra

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 4

I am not sure I understand your question. The source is defined at the package level. The Execute SQL task looks to that definition.