Export to Excel - 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

General SQL Server Forums

New to SQL Server Programming

Export to Excel

Author

Topic

jfkennedy5
Starting Member

6 Posts

Posted - 2007-02-18 : 08:20:33

Hello All

First time setting up A SSIS

Trying to import a excel that creates a new table called lockbox.

Does not import any records from Columns-Contract Id, Owner ID,
that have a null value.

Then in the Site Id -that is a number value- change to a text value
and update it to it text value.

for example: Site Id Column
2 = Ell
3 = CSI
12 = Ell2

Can someone get me started in the right direction?

Thanks for your time and help

JK

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-02-19 : 10:22:36

Duplicate
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79311

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources