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'.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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!
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
August 7, 2012 at 6:28 am
ok thanks.
August 8, 2012 at 6:24 am
August 8, 2012 at 7:19 am
And here it is again as a hyperlink:
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply