SSIS - Data Type Issue

Question

SSIS - Data Type Issue

rjjh78

SSCrazy

Points: 2787
More actions
February 23, 2016 at 10:44 am

#316248

Hello,
I am using SSIS for FTP and am having an issue when trying to use the ServerPort expression. The ServerPort expression is expecting an Int16, however my Port datatype is int in my database.
I have found that this is an issue with VS2008 (which I am currently using) and am looking for a possible work around.
I have a port number that contains 4 numbers (e.e. 2121), could this be part of the problem?
Any advice and intel is sincerely appreciated.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110651 More actions · Answer 1

Not sure what data types you can cast to, but a 4 digit port number still fits easily into a 16-bit integer, as the range of values for an unsigned 16-bit integer value are 0 to 65535. That provides the full range of port numbers for network connections of any flavor. The problem might just be that data type conversion might need to come up rather than down in order to work, which might be a problem with any port number larger than 255. Not sure what your exact situation is...

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

sgmunson SSC Guru Points: 110651 More actions · Answer 2

You might want to try CAST(PortNumber AS smallint)...

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 3

sgmunson (2/23/2016)
You might want to try CAST(PortNumber AS smallint)...

This or try to change the INT16 in expression to INT32. But yes, INT in a database comes across as INT32 in SSIS, so you'll need to convert or cast something. Steve's suggestion is the better one (Mine, not so much because you might need to flip it a second time).

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

sgmunson SSC Guru Points: 110651 More actions · Answer 4

Brandie Tarvin (2/25/2016)
sgmunson (2/23/2016)
You might want to try CAST(PortNumber AS smallint)...
This or try to change the INT16 in expression to INT32. But yes, INT in a database comes across as INT32 in SSIS, so you'll need to convert or cast something. Steve's suggestion is the better one (Mine, not so much because you might need to flip it a second time).

Thanks Brandie... Hey rjjh78, ... let us know if the CAST to smallint solves the problem, or if you're still running into a problem.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)