Automatically loading excel files into SQL Table

Question

Post reply

Automatically loading excel files into SQL Table

akani.alaka

SSC Rookie

Points: 48
More actions
May 5, 2008 at 12:00 pm

#121939

Hello all:
My name is Akani. I am trying to automatically load an excel file into an SQL table. How can I do this? I am running MS SQL Enterprise Manager 8.0. After I set it up from Enterprise Manager, can I use the NT Scheduler to kick off? Or do I have to write some codes in ASP to accomplish this? Please help!
I saw the following code from Suzan:
1. create a bulk insert task to control flow
2. excell source
3. ole DB destination source
Would these lines help me accomplish the task? Where and how do I execute these lines if possible?
Thanks again....

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jim SSCrazy Eights Points: 8720 More actions · Answer 1

Are you trying to do DTS in 2000 or SSIS in 2005?

akani.alaka SSC Rookie Points: 48 More actions · Answer 2

Thanks for the reply... DTS in 2000... If there are other alternatives that you know of, by all mean, please advise me...

Thanks

Jim SSCrazy Eights Points: 8720 More actions · Answer 3

Once you have the DTS package created in Enterprise Manager, right-click on the package and select Schedule Package. This will setup the schedule to run inside of the SQL Agent.

If you need to run this as a command line external to the SQL Agent, open the newly created job and go to the step it created. The command line inside of that step is what you will issue at the command prompt.

akani.alaka SSC Rookie Points: 48 More actions · Answer 4

Thanks again. You have been very helpful!!

I was able to create the DTS package and schedule it. To run it from the command line, you asked me to "... open the newly created job and go to the step it created. The command line inside of that step is what you will issue at the command prompt"

However, whenever I open the package, I see a diagram depicting the source, destination and connection of the package. No mention of where I may find the STEPS...

What am I doing wrong???

thanks again... and sorry if I am asking dum questions...

Jim SSCrazy Eights Points: 8720 More actions · Answer 5

There is no such thing as a "dumb question" if you don't know the answer...

To answer your question, when you schedule the package to run, it creates a job in the SQL Server Agent. Under Management, expand SQL Server Agent and then select Jobs. Double-click the job that you just created, click on the steps tab and then highlight and edit the step. You'll find the command line in that window.

akani.alaka SSC Rookie Points: 48 More actions · Answer 6

Thank you soooooooooooooo much. You are a blessing. I wish I could see you and hug you!