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
LukeConeyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
HoggZillaConnect With a Mentor Commented:
Some additional information is required to help. At what point are you getting the Unicode / Non Unicode error message? Assuming you are saving the file to SQL Server, check your column data types, I reccommend using varchar over nvarchar. This fixes most Unicode conversion issues.

About using the same package for multiple file sources, this is difficult unless each file has the same layout, columns and data types and importing to the same destination.

SSIS is very flexible but with that, not very friendly. If you need something more dynamic I suggest another tool. If it is the same thing, over and over, SSIS is great.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Are you defining these 'other flat file sources' as the same connection, or different connections?
0
 
jorge_torizResearch & Development ManagerCommented:
To fix your characterset problems use a data conversion task
0
All Courses

From novice to tech pro — start learning today.