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!

Convert Code to Variable

Status
Not open for further replies.
klewis10367

klewis10367

MIS
Mar 12, 2003
678
US
Any Idea how I would convert the following SQl query to a variable expression in SSIS:

Code: 
@FromDate = CONVERT(datetime, floor(CONVERT(float, GetDate()))) 
+ [User::EOD]

 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
CSV to SQL table with not allow null issue
Replies
3
Views
443
Cpreston
Cpreston
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
1K
mark williams
mark williams
dbsql
  • Locked
  • Question
get existing record from source to destination
Replies
0
Views
258
dbsql
dbsql
kfschaefer0727
  • Locked
  • Question
New to SSIS - Create pkg to validate data, does it exists in a table
Replies
0
Views
266
kfschaefer0727
kfschaefer0727
arunaramana
  • Locked
  • Question
use case to 'Name and Extension', 'Full Qualified' and 'Name Only' options in foreach file enumerato
Replies
0
Views
266
arunaramana
arunaramana

Part and Inventory Search

Sponsor

Back
Top