pull data with ssis - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

pull data with ssis

Author

Topic

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-08-19 : 08:17:10

i pull data with ssis

in SQL 2000 ,when i pukk data i get some fields with type varchar
in SQL 2005 i get some diels with type nvarchar

why?how can i get the fields with type varchar?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-08-19 : 10:28:36

you need to edit the mappings in the package.

that was true in sql 2000 also

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-08-22 : 14:01:04

i mean that:
SQL 200:when i pull table A ,i get the fields with type varchar
(in Transotm Data Task Properties
i choose destination and then i choose create table)
but in sql 2005 when i pull table A i get the same fiels with type nvarchar
(in OLE DB Destination i choose create table then i get on some fields nvarchar instead varchar like 2000)

how it could be?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources