SSIS - 05-02-2006 , 08:28 AM
I have just started working with SSIS and to say I find it complicated is an
understatemnet but from what I have read a lot of other people are having the
same troubles, all I want to do is transfer some data from a Tab delimited
file into a sql table which using DTS was nice, quick and simple but with
SSIS it's none of these. I am now getting an error saying that it cannot
convert between unicdode and non-unicode string data types, can someone help
me out, considering this was done using the migration from DTS tool you think
it would be clever enough to use the correct data types.
Hope someone can help and I'm sorry about the rant.
RE: SSIS - 05-02-2006 , 08:59 AM
Further to this post I think I may have got rid of one problem and replaced
it with another, I have got run of the unicode problem but I am now getting
the following message
Warning: 0x80047076 at DTSTask_DTSDataPumpTask_4, DTS.Pipeline: The output
column "Col001" (10) on output "Flat File Source Output" (2) and component
"Flat File Source" (1) is not subsequently used in the Data Flow task.
Removing this unused output column can increase Data Flow task performance.
I really dont have a clue what this is telling me or how to make it go away,
would appreciate any help offered.
RE: SSIS - 05-03-2006 , 12:07 PM
Honestly, with my experience so far with SSIS, it is no good for loading a
flat file to a sql table. I scratched my head for days to get around with
this unicode, lenth mismatch and datatype problem in SSIS, where DTS was much
better in data massaging. To get around with this problem now what i have
started doing is using DTS in SSIS. So now i take the advantage of both SSIS
and DTS. the things which i like of DTS i use DTS and the feauture i like of
SSIS i use SSIS. So if you want to do that way then you can use 'Execute DTS
2000 package' task in control flow. Double click on that and create a package
to load the flatfile to sql table in DTS designer. this works good for me.
RE: SSIS - 02-24-2009 , 05:39 AM
I am also getting these warnings but my package is executing successfully,
but it is not updating records in tables
From http://www.google.co.in/search?hl=en&q=The+output+column+on+output+"Flat+F ile+Source+Output"+(2)+and+component+"Flat+File+So urce"+(1)+is+not+subsequently+used+in+the+Data+Flo w+task&btnG=Google+Search&meta=
Posted via DevelopmentNow.com Groups