how to automate the data load

[ddtpmyra]

Hi!
I dont have any scripts to add right now. But I need help to give me idea how to do automated one. I used to do it on Oracle on Unix using .bat file and calling the text file containing my sqlloader command.

Now Im facing MS SQL Server 2003 ofcourse on Windows. Anybody can share a thoughts on this or a sample step by step on how to do it?

thanks!

[ck9663]

There are a lot of factors to consider regarding your question.

1. Frequency of execution. Since you're asking about automation, I assume this will be executed more than once, in some defined frequency.

2. File size.

3. File type.

There are a number of options to automate your process.

1. Develop an external module (VB, Java, C, etc). Parse the file, connect to db and insert record. Use a scheduler if necessary.

2. Create a package in SSIS. Create a job to call the package.

3. Script it. Create T-SQLs, create a job to call the SP.

4. Buy an Integration Software, aka ETL Tool.

Good Luck!!!

~~ CK

[ddtpmyra]

CK,
do you have sample code on VB?

[ck9663]

No. Try posting this on the VB/ASP/.Net forum. They might be able to help you more...

Good Luck!!!

~~ CK