Posted by Dan Guzman on 08/31/06 11:11

To add to Erland's response, you can use a SQL Agent job to schedule the
import process. In the case of a package created with SSMS or the BI dev
studio, there is a specialized SQL Server Integration Services step type
that allows you to specify the desired package and run time settings via a
GUI.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"mattc66 via SQLMonster.com" <u16013@uwe> wrote in message
news:65826d5d02090@uwe...
>I have data that comes from a legacy system. I can obtain the data in an
> ASCII format. Currently I have created scripts in ACCESS to import the
> data
> into tables.
>
> What I would like to do is create an automated import function in SQL.
>
> I am new to SQL, can anyone point me in the direction I should look to
> find
> out how I could perform this task?
>
> Using SQL 2005.
>
> Thanks
> Matt
>
> --
> Matt Campbell
> mattc (at) saunatec [dot] com
>
> Message posted via http://www.sqlmonster.com
>
>

• Next in forum: Stored Procedure to return table?
• Prev in forum: Calculating Positions Query Required...........
• Thread view: Re: Import ASCII Data

[Reply to this message]