?
Solved

SSIS package problems

Posted on 2008-10-07
4
Medium Priority
?
379 Views
Last Modified: 2013-11-10
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
0
Comment
Question by:LukeConey
3 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 22658624
Are you defining these 'other flat file sources' as the same connection, or different connections?
0
 
LVL 15

Expert Comment

by:jorge_toriz
ID: 22674772
To fix your characterset problems use a data conversion task
0
 
LVL 17

Accepted Solution

by:
HoggZilla earned 1000 total points
ID: 22711382
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

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

568 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question