importing external data

[Dimitrie1]

I need to import external data - daily for about 6 months. I'd like to automate this process.

I've tried bulk insert, openqueryrow, ssis --- nothing is working - any ideas.

 

[SQLSister]

We do many many imports daily with SSIS, that is one of it's main jobs.

I think it will be hard to help you without more detail. What is the error you are getting?

"NOTHING is more important in a database than integrity." ESquared

 

[Dimitrie1]

I'm trying to use a bulk insert
it doesn't error it just says 0 rows affected.

when I used SSIS I couldn't find the package in SQL Management Studio. If I saved it to my desktop it errored when trying to run - sorry I don't remember the msg, something about permissions

 

[simian336]

Someone provided this link the other day in anouther thread. You might find it helpful.

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/title-12

Simi

 

[Dimitrie1]

thanks

this is my current code

BULK INSERT  .
#morecheques    FROM '\\server\path\Test_Subsequent.csv'
with
(
firstrow = 2,
fieldterminator = '\t',
rowterminator = '\n'
)
[\code]

it doesn't error but it tells me 0 rows affected.