SSIS

[Phil]

Hi,

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.

Thanks PD

[Phil]

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.

Thanks PD

Post by Phil
Hi,
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.
Thanks PD

[SP]

This post might be inappropriate. Click to display it.

[prakash gupta]

I am also getting these warnings but my package is executing successfully,
but it is not updating records in tables

please help.....
thanks
prakas

From http://www.google.co.in/search?hl=en&q=The+output+column+on+output+"Flat+File+Source+Output"+(2)+and+component+"Flat+File+Source"+(1)+is+not+subsequently+used+in+the+Data+Flow+task&btnG=Google+Search&meta

Posted via DevelopmentNow.com Group
http://www.developmentnow.com/g/