Link to home
Start Free TrialLog in
Avatar of LukeConey
LukeConey

asked on

SSIS package problems

I saved an SSIS package in micosoft sql server and i want to now use the same package so i can import other flat file sources,, i want to be able to use this as i dont want to keep having to manually fixed width every file and its time consuming

I have opened the package in Microsft visual basics and it keeps comin up with a unicode and non unicode error message

Is this the right way to use the package to import other files

Please let me know as im stuck
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Are you defining these 'other flat file sources' as the same connection, or different connections?
To fix your characterset problems use a data conversion task
ASKER CERTIFIED SOLUTION
Avatar of Steve Hogg
Steve Hogg
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial