Advertisement

07.11.2007 at 12:48PM PDT, ID: 22689869
[x]
Attachment Details

Declaring Variables In SQL Tasks Within DTS Packages

Asked by salesprod in MS SQL DTS, MS SQL Server

Tags: , , , ,

I have a SQL task in a DTS procedure.  In the sql task, I declare a variable and set it a value using GetDate().  I run my package and it errors stating the following message: "Must declare variable @GetDate".  I even tried declaring it on my package, however, it is a datetime type.  It did not work also!  Can anyone provide any guidance on this?

Thanks!   Start Free Trial
[+][-]07.11.2007 at 02:35PM PDT, ID: 19466987

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.11.2007 at 02:39PM PDT, ID: 19467011

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.11.2007 at 03:49PM PDT, ID: 19467414

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL DTS, MS SQL Server
Tags: variables, sql, datetime, declaring, dts
Sign Up Now!
Solution Provided By: nmcdermaid
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32