By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,362 Members | 1,337 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,362 IT Pros & Developers. It's quick & easy.

DTS to .exe! HOW?

antonopn
P: 42
Hello there,

I' a newbie here and I try this thing with no success.

I've made a data transformation parckage (DTS) in SQL SERVER 2000. It creates a table, copies data into in and alters it.

I want to make a dll (or a type of executable file) in which this process is done automatically, not by opening enterprize manager etc.

I've tried doing it by saving it as a .bas file but I miss something...

Can you please help me?

THANK YOU FOR YOUR TIME AND YOUR PATIENCE!!!!
Mar 29 '08 #1
Share this Question
Share on Google+
2 Replies


antonopn
P: 42
In fact the whole process is running. The only file I execute is the producted .bas file.
I found that I should have ckecked on project->properties three microsoft dts libraries.

The only problem I have right now is that the dts is made by import wizard. I import data from a text file, into a table I create.

The table is created but there is no data in it after executing the .bas file! If I execute the dts package the process is done normaly.

Any suggestions PLEASE?
Mar 31 '08 #2

ck9663
Expert 2.5K+
P: 2,878
Do it the other way around. Create your DTS as package. Create an job that will run this DTS in a regular basis (maybe monitor a folder if a file is there).

-- CK
Mar 31 '08 #3

Post your reply

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