import xml files into sql - 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)

import xml files into sql

Author

Topic

100csc
Starting Member

1 Post

Posted - 2009-03-23 : 13:04:46

hi

I wil be geting daily aroun 40,000 of xml files
i am asked to create a package where it takes those files and saves into Db in table 1 and once they are saved
in DB tht whole xml file should be saved as image in another table2 in sql
and once this is done all the files must be delected

I created half where i used for eeach loop and data flow task n file task
this package takes all the xml files and saves into Db into table 1
and deletes those files

I need to know how those files can be saved in table 2 as image
i am giving the table 2 desc

CREATE TABLE table 2(
[ID] [INT] NOT NULL,
[FileName] [nvarchar](max),
[DATA] [image] ,
[time_stamp] [smalldatetime] NULL DEFAULT (getdate()),
[active] [bit] NULL DEFAULT ((1))
)

thankyou

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-15 : 18:05:52

Why are you using IMAGE datatype in favor of XML datatype?

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources