automatic data import

I just got sql 2005. Can someone point me in the right direction on getting started importing data. I need to be able to load ascii data into SQL 2005 on a weekly basis. This ascii file will have the same data structure but data will change weekly.

I have heard to do this automatically (basically with a click of a button) you should use a DTS package. I also see this SSIS. I am trying to understand what to use for this import process. I would really appreciate any help on this. Thanks.

Start with the Import Wizard (in SQL Server Management Studio).

-Jamie

Automate Oracle import to SQL

We are looking at setting up a SQL report server which automates the task of importing Oracle tables. However it seems to be an unknown how to reliablily and automatically import tables from Oracle into SQL. The total size is 500Meg now but will probably grow to a couple of gigs before long. Importing needs to not take too long and would be good if people could still query the data while the update is occuring. So I believe we need to append tables only.

Any suggestions for this noob.

Thanks,Well, the basic approach would be to create a set of stored procedures which would append the SQL tables from the Oracle tables based on simple outer joins. They could be kicked off periodically as a SQL Server Agent job.

DTS (Data Transformation Services) allows you do do the same thing, but gives you a nice GUI for configuring everything. You add a server connection for the Oracle server, a server connection for your SQL Server, and define individual transformation steps for each of your tables. You can customize the source SQL to include only new rows (again, outer joins based on table keys), and transform the data along the way if youd like. Again, the DTS package can be kicked off on a schedule by SQL Server Agent.

I haven't done a lot with DB Replication, but I think it's pretty much SQL to SQL, so I'm not sure how much that would help. The first two approaches would give you everything you are looking for, I would think.
I use the first approach to warehouse data from nine Informix servers every 5 minutes. Works pretty well.

-b|||Well ... the best approach would be to create a linked server and a repository of the tables you will need to transfer. Then you can write a stored procedure to dynamically make queries to transfer the data from oracle to SQL server.

Auto importing files

Hi, I am running sqlserver and I have a directory taking file dumps, what I need to do is have the database auto import the file into a table, but I want to avoid using asp.net (I had considered using a filecatcher), I want to limit what I use to VB or sqlserver components so other people in my area can also support it.

any help or pointers in the right direction would be appreciated.

which version of sql server you have? if its sql server 2000 you can try DTS and if its 2005 try 2005. BTB what type of file you receive?

Madhu

|||I am using 2005|||

Hope its not Express. if its express SSIS will not work. otherwise , you can create SSIS for file porting and you can schedule as u want using sql server job

Madhu