SSIS Variable Expressions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS Variable Expressions

15 posts, Page 2 of 2

««1 2

SSIS Variable Expressions

Rate Topic

Display Mode

Topic Options

Author

Message

Carol Adams

Posted Tuesday, April 21, 2009 8:49 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 7:10 AM
Points: 60, Visits: 284

i have vadb15\vabiv... this is a sql instance on the vadb15 server.

Post #702015

Tim Mitchell

Posted Tuesday, April 21, 2009 9:03 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 9:12 PM
Points: 1,034, Visits: 2,611

It sounds like you're covering all your bases... not sure what's going on here.

How are you setting your variable value - is it set on creation (in the Variables window on the left) or are you setting it within the flow of your program, such as a ForEach loop or similar?

Check the scope of your variable - is it set at the Package level?

Can you post the exact error message you're receiving?

Tim Mitchell
SQL Server MVP
www.TimMitchell.net
@Tim_Mitchell

Post #702018

Carol Adams

Posted Wednesday, April 22, 2009 5:51 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 7:10 AM
Points: 60, Visits: 284

It is defined on the left side of the screen as a "Package" variable.
I have an "Execute Sql Task" that populates the variable.
My Execute SQL Task General Tab has a ResultSet of SingleRow, Connection Type OLE DB, Connection of CCXXSDDB010.ietenterprise, SQL SourceType of Direct Input,
and just to test I have a SQL Statement of "SELECT 'rePORTAL_OLD' AS databasename"

Within the Result Set properties I have RESULT NAME set to databasename and VARIABLE NAME set to User::InDatabase

Nothing under the expressions properties window.

When I do set a VALUE on the left window for the variable and disable the EXECUTE SQL TASK, the stream runs.

WHen I clear out the VALUE on the variable and enable the EXECUTE SQL TASK, before it even gets to the 2nd step which is to popup a msgbox with the database name, it aborts with the following message:

TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at Transfer Database Task [Transfer Database Task]: A source database must be specified.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------
BUTTONS:

OK
------------------------------

Post #702243

Tim Mitchell

Posted Wednesday, April 22, 2009 6:54 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 9:12 PM
Points: 1,034, Visits: 2,611

OK, that means there's something in your Execute SQL Task that is not working properly. Can you post details about that task?

Tim Mitchell
SQL Server MVP
www.TimMitchell.net
@Tim_Mitchell

Post #702295

Carol Adams

Posted Wednesday, April 22, 2009 7:07 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 7:10 AM
Points: 60, Visits: 284

My Execute SQL Task General Tab has a ResultSet of SingleRow, Connection Type OLE DB, Connection of CCXXSDDB010.ietenterprise, SQL SourceType of Direct Input,
and just to test I have a SQL Statement of "SELECT 'rePORTAL_OLD' AS databasename"

Within the Result Set properties I have RESULT NAME set to databasename and VARIABLE NAME set to User::InDatabase

Nothing under the expressions properties window.

Post #702311

« Prev Topic | Next Topic »

15 posts, Page 2 of 2

««1 2

Permissions