• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1002
  • Last Modified:

DTS activeX script msgbox troublehsooting

MsgBox(datePassed)
DTSDestination("TRNDT")= datePassed
MsgBox(TRNDT)


The datePassed field has a value of 20050312

but the box for TRNDT is blank why?

thanks,

Don
0
dprice7
Asked:
dprice7
  • 3
  • 2
1 Solution
 
Anthony PerkinsCommented:
Change:
MsgBox(TRNDT)

To:
MsgBox(DTSDestination("TRNDT"))
0
 
dprice7Author Commented:
MsgBox(DTSDestination("TRNDT"))

ok the value is good but the package does not work.

message is DTSTransformation_1 encountered an invalid data value for "TRNDT" destination column.

thanks,

DOn
0
 
arbertCommented:
"ok the value is good but the package does not work."

acperkins answered your original question.....Your questions seem to get a little long and I believe you expect a little more from experts than you should--this is free volunteer time....
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Anthony PerkinsCommented:
>>message is DTSTransformation_1 encountered an invalid data value for "TRNDT" destination column.<<
This means you have an invalid data value for the TRNDT column.
0
 
dprice7Author Commented:
acperkins,

Sorry I get carried away when I am learning something.

Never mean to take advantage,

thanks,

Don
0
 
Anthony PerkinsCommented:
No problem.

Anthony
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now