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
 Data import into SQL db

Author  Topic 

Ash1807
Starting Member

10 Posts

Posted - 2015-03-05 : 02:44:02
Hi
A newbiere, ok with SQL statements, but not very familiar with all the server component toolsets

I have a DB with a few related tables. I need to set up an automated import of a text file to completely replace an existing table data. There will be no translation involved, but a re-map

Lokking around, a lot of words on Integration services and then using a stored procedure to schedule the package.

The question is, is this the preferred method, and any pointers to any posting that would give me a good overview of the steps needed

KR
ash

Ash Gajjar

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-05 : 04:13:25
SSIS plus SQL server agent
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-05 : 04:13:56
SSIS plus SQL server agent
Go to Top of Page
   

- Advertisement -