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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sum DTSSource fields to get DTSDestination value
- Thread starter texusgirl
- Start date
- Thread starter
- #2
Hey everyone,
No need to reply to this one, I figured out the problem. I had my syntax correct DTSDestination("fieldname"
= DTSSource("fieldname" + DTSSource("fieldname" etc...
The problem was that my destination and source were two different data types, I had to convert first and then it worked. Thanks anyway, maybe this will help someone else?![[surprise]](/data/assets/smilies/surprise.gif "[surprise] [surprise]")
No need to reply to this one, I figured out the problem. I had my syntax correct DTSDestination("fieldname"
= DTSSource("fieldname" + DTSSource("fieldname" etc...The problem was that my destination and source were two different data types, I had to convert first and then it worked. Thanks anyway, maybe this will help someone else?
- Status
Similar threads
