dbTalk Databases Forums  

(using SSIS) how to data transformation and import into sql

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss (using SSIS) how to data transformation and import into sql in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Luke
 
Posts: n/a

Default (using SSIS) how to data transformation and import into sql - 05-23-2006 , 12:34 AM






how to use SQL Server 2005 Integration Services (SSIS)?

Our company needs to frequently import 1000s of records from a 3rd party app
on a daily basis. And this info has to be imported into SQL.
Sometimes the number could be in the rage of 100,000 or millions of records.

The data will be in flat files (delimited text files), and we'll need to
perform some validations, transformations and then import them into SQL
server (into the necessary tables).
Some keys will have to be auto-generated, whereas in others, existing data
will be used as PKs.

I know that DTS is the way to go, and in SQL 2005 its SSIS.
We're using SQL 2005, and this process will be done on a daily basis.

Can someone direct me on how to proceed with the above task.
I.e. where can i start, do I have to learn about SSIS in SQL 2005?

Any help on the above, is much appreciated.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.