Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how do I access a DTS Global Varible (datatype=DATE

Status
Not open for further replies.
btturner

btturner

Programmer
May 17, 2001
175
US
In "DTS Exec SQL Task" how do I access a DTS Global Varible (datatype=DATE) from an invoked SQL Stored Procedure.

I am invoking the SP passing the GV to it.. but receive the following err msg:

ERROR CONVERTING DATATYPE NVARCHAR to DATETIME (

The GV is a DATE datatype.. I want to use this GV in a datrange comparison!!!!!!!!
 
Status
Not open for further replies.

Similar threads

isoman4not5
  • Locked
  • Question
Is it possible to derive a recurring date based upon a single date?
Replies
0
Views
468
isoman4not5
isoman4not5
dcern
  • Locked
  • Question
Ingres ODBC Driver slow
Replies
0
Views
495
dcern
dcern
acoronel
  • Locked
  • Question
Error message to use active directory authetication to access SQL database.
Replies
0
Views
461
acoronel
acoronel
maxzikpi
  • Locked
  • Question
How to Create a cube with a survey result. Pls help!
Replies
4
Views
545
maxzikpi
maxzikpi
chainedtodesk
  • Locked
  • Question
update AS400 table from MS Access db
Replies
0
Views
449
chainedtodesk
chainedtodesk

Part and Inventory Search

Sponsor

Back
Top