Import file into MS SQL 2008 DB

Dissuss issues not related to other forums

Import file into MS SQL 2008 DB

Postby melvin » Mon Jan 19, 2015 4:26 pm

User support request:

Is the database task has capable of importing a txt file or csv into our MS SQL 2008 DB?
melvin
Site Admin
 
Posts: 983
Joined: Thu May 25, 2006 10:20 am
Location: Santa Barbara, california

Re: Import file into MS SQL 2008 DB

Postby melvin » Mon Jan 19, 2015 4:26 pm

You need to create a Database stored procedure within the ms sql database. You can then run this procedure using the Database stored procedure task.
melvin
Site Admin
 
Posts: 983
Joined: Thu May 25, 2006 10:20 am
Location: Santa Barbara, california


Return to Other

Who is online

Users browsing this forum: No registered users and 0 guests

cron