469,085 Members | 1,020 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,085 developers. It's quick & easy.

how to automate the data load

ddtpmyra
333 100+
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!
Oct 26 '10 #1
3 1888
ck9663
2,878 Expert 2GB
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
Oct 26 '10 #2
ddtpmyra
333 100+
CK,
do you have sample code on VB?
Oct 27 '10 #3
ck9663
2,878 Expert 2GB
No. Try posting this on the VB/ASP/.Net forum. They might be able to help you more...

Good Luck!!!

~~ CK
Oct 27 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Catch_22 | last post: by
4 posts views Thread by Frank | last post: by
6 posts views Thread by Frank | last post: by
reply views Thread by asheesh.rastogi | last post: by
2 posts views Thread by Rick Shaw | last post: by
reply views Thread by akp123 | last post: by
10 posts views Thread by sai1001 | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.