Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mr4100
Starting Member
6 Posts |
 Posted - 2007-10-30 : 10:58:14
|
| I'm trying to convert an int to a string in my expression in ssis. Is this possible? I keep getting an error and I've also tried the cast operator, can't figure it out! Can someone help?@[User::Path]+ "DEN" + Cast(@[User::Counter] as string)thanks,Mike |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-30 : 11:22:25
|
| I don;t know anything about SSIS in this regard, but a SQL Cast of an INT to a STRING would normally be:Cast(@[User::Counter] as varchar(20))Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-31 : 02:00:54
|
quote:
Originally posted by mr4100
I'm trying to convert an int to a string in my expression in ssis. Is this possible? I keep getting an error and I've also tried the cast operator, can't figure it out! Can someone help?@[User::Path]+ "DEN" + Cast(@[User::Counter] as string)thanks,Mike
Did you get any error?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
convert