ssis and import issue - 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)

ssis and import issue

Author

Topic

eirikr
Starting Member

18 Posts

Posted - 2008-12-15 : 18:07:47

i get an error message when i try to import an excel databse into a table in sqlserver 2005, the error something about connection to sql failed, no such host is known when i set ms sql native client. Please tell me why, and what should i do. Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-15 : 18:16:00

Choose data flow task and put excel source and OLEDB destination.Point them to right connection.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-15 : 19:27:34

You might need to change unicode to appropriate data type while importing.

eirikr
Starting Member

18 Posts

Posted - 2008-12-16 : 16:26:29

i followed exactly as shown in the book:
-data src: ms excel
with excel file path, then next

with dest, i tried either:
-dest: OLEBD for sql, or SQL native client
with my server name

Then i chose copy data from one to more tbls ...

everything seems working, but i failed at validating, error 0xc0047ofe, something with data flow task, the product level is insufficient for component source . What should i do? please help

eirikr
Starting Member

18 Posts

Posted - 2008-12-16 : 16:36:23