how to import .unl file

I have made the exact replica of a database in SQL server 2005, and i got unloads from an Informix database.

How do i load them into my SQL server database?

I would have a look at SSIS and use the import tools to import the data. You will need to make sure that the informix data drivers are installed on the machine where you are running the import on. Also with this you could connect directly to the database (Informix) and transfer the data.

With the unl file as this could be one omany formats you would have to look at the files and see what they look like, from memory these are either comma dilimited or will be tab delimited files and you should be able to use the text import tools inside SSIS to load the files into your new tables.

How to implement incremental load in fact tables.

Hi all,

i have a fact table which loads through package,when

i m trying to load this table by running the package,i m truncating the

fact table and loading the fresh data,instaed of this without

truncating the fact table i have to implement the incremental logic in

this.

For this i can use SCD or Conditional split,but problem

here is i have many source tables to load this fact table,so its

very difficult to trace the changes in different source tables.

can any one help me out in this?You should stage all of your source tables along with the current load date. That way, when you select from your source staging tables, you can retrieve the data based on that date field, thereby only picking up the new/changed records.

How to I load XML into SQL Server 2000

I feel like I must be missing something because there
doesn't seem to be a simple solution to this problem. I
have an XML document and a DTD document and I want to load
this information into SQL Server.
I try to use DTS import but I keep getting the error
message "SQLOLEDB must be specified as the data provider".
Am I asking too much here?Bob: This can be accomplished using OPENXML in SQL 2000:
http://www.sqlxml.org/faqs.aspx?faq=39.
Jay Nathan
http://www.jaynathan.com/blog
"Bob Smith" <anonymous@.discussions.microsoft.com> wrote in message
news:10ca01c4e54a$cdc35e10$a401280a@.phx.gbl...
> I feel like I must be missing something because there
> doesn't seem to be a simple solution to this problem. I
> have an XML document and a DTD document and I want to load
> this information into SQL Server.
> I try to use DTS import but I keep getting the error
> message "SQLOLEDB must be specified as the data provider".
> Am I asking too much here?

How to I load XML into SQL Server 2000

I feel like I must be missing something because there
doesn't seem to be a simple solution to this problem. I
have an XML document and a DTD document and I want to load
this information into SQL Server.
I try to use DTS import but I keep getting the error
message "SQLOLEDB must be specified as the data provider".
Am I asking too much here?
Bob: This can be accomplished using OPENXML in SQL 2000:
http://www.sqlxml.org/faqs.aspx?faq=39.
Jay Nathan
http://www.jaynathan.com/blog
"Bob Smith" <anonymous@.discussions.microsoft.com> wrote in message
news:10ca01c4e54a$cdc35e10$a401280a@.phx.gbl...
> I feel like I must be missing something because there
> doesn't seem to be a simple solution to this problem. I
> have an XML document and a DTD document and I want to load
> this information into SQL Server.
> I try to use DTS import but I keep getting the error
> message "SQLOLEDB must be specified as the data provider".
> Am I asking too much here?