August 3, 2012 at 11:13 am
I have about ten SSIS packages that use varchar and char columns in tables. Most are built from the wizard.
Is there a simple way to change the columns from varchar to nvarchar to update the SSIS package? We also may be adding some length to the fields.
August 6, 2012 at 3:18 am
By 'simple', I presume you mean without going through the packages and editing the meta data manually? I'm afraid the answer is 'no'.
August 6, 2012 at 11:13 am
Unless you need the extended international character set, you should probably stay with varchar.
To change all the reports I would open the reports code (view code) and do a Find/Replace. But don't do a Replace All or you may find that you change some things you didn't intend.
August 6, 2012 at 2:13 pm
Daniel Bowlin (8/6/2012)
Unless you need the extended international character set, you should probably stay with varchar.To change all the reports I would open the reports code (view code) and do a Find/Replace. But don't do a Replace All or you may find that you change some things you didn't intend.
This is SSIS, not SSRS!
August 7, 2012 at 6:28 am
ok thanks.
August 8, 2012 at 6:24 am
August 8, 2012 at 7:19 am
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply