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'.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
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!
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
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:
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply