Running a DTS

Hi there
I've been trying to do this all w and it's driving me mad !
All I want to do is run a DTS import from a SQL script. When it's run
manually it takes 15 seconds.
The Dts is called "DTS_LisImport"
The DB is "sqlReleaseTwo"
I'm running SQL7
Many thanks
Paul.try
[url]http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_11959518.html[/ur
l]
"Paul in Harrow" <PaulinHarrow@.discussions.microsoft.com> wrote in message
news:D0CC5A4A-5E73-4A91-A17C-344852ED2F7D@.microsoft.com...
> Hi there
> I've been trying to do this all w and it's driving me mad !
> All I want to do is run a DTS import from a SQL script. When it's run
> manually it takes 15 seconds.
> The Dts is called "DTS_LisImport"
> The DB is "sqlReleaseTwo"
> I'm running SQL7
> Many thanks
> Paul.
>|||See if this helps: http://www.sqldts.com/default.aspx?210
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Paul in Harrow" <PaulinHarrow@.discussions.microsoft.com> wrote in message
news:D0CC5A4A-5E73-4A91-A17C-344852ED2F7D@.microsoft.com...
Hi there
I've been trying to do this all w and it's driving me mad !
All I want to do is run a DTS import from a SQL script. When it's run
manually it takes 15 seconds.
The Dts is called "DTS_LisImport"
The DB is "sqlReleaseTwo"
I'm running SQL7
Many thanks
Paul.|||Tried something different:
Use msdb
execute sp_start_job @.job_id= "7B42CBCD-A615-4CF4-B204-8FE4A31E65B1"
[Open sysjobs_view in msdb to get the job_id]
gives me: "Job 'DTS__LisImport' started successfully."
Is there a sp_run_job anywhere?
Paul

RUN SQL Stored Procedure in Access

Hi there
I have a SQL stored procedure which I would like to run through Access.
This procedure has a paramert.
I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.

I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)

Thank you very much.
Regards.
Pete

Quote:

Originally Posted by petr_podskubka

Hi there
I have a SQL stored procedure which I would like to run through Access.
This procedure has a paramert.
I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.

I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)

Thank you very much.
Regards.
Pete

I would like to know if you would have information I trying to find information on how can I have my SQL stored procedure through Access...

Thank you for helping

|||

Quote:

Originally Posted by petr_podskubka

Hi there
I have a SQL stored procedure which I would like to run through Access.
This procedure has a paramert.
I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.

I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)

Thank you very much.
Regards.
Pete

it will be a little bit of both...you need the VBA to establish connection and some setting. although there are objects that can handle some of these tasks, you still might need some VBA coding to handle some stuff, ie, error handling.

|||Try this:

http://archives.postgresql.org/pgsq...05/msg01260.php

Basically what it does, it changes text of your query every time you pass parameters.
The best part it is ready to use you dont need to write it yourself.

Good Luck.

Irina.|||

Quote:

Originally Posted by petr_podskubka

Hi there
I have a SQL stored procedure which I would like to run through Access.
This procedure has a paramert.
I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.

I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)

Thank you very much.
Regards.
Pete

Look at ADP files in Access stored procedures are exposed in the GUI interface along with views you enter paramters for the stored procedure via the Forms Inputparameters property of the form

Regards

Jim

|||

Quote:

Originally Posted by Jim Doherty

Look at ADP files in Access stored procedures are exposed in the GUI interface along with views you enter paramters for the stored procedure via the Forms Inputparameters property of the form

Regards

Jim

As I understood this question it is a pass through query that runs on SQL Server side and not on Access side.

|||

Quote:

Originally Posted by iburyak

As I understood this question it is a pass through query that runs on SQL Server side and not on Access side.

Hi Iburyak,

You're probably right of course and me way off the mark at the end of the day :)... but the poster simply mentioned 'Access' and my presumption is that they might not be aware that in Access .ADP files as distinct from mdb files were intended to work directly with SQL Server. The connection method is (universal data link) automated within the interface they might want to consider their options?

Regards

Jim

Run child package independently [FOUND IT]

Hi there

I have a parent package which execute a child package. But when the child package is run from the parent not all of the tools inside is executed. I have a variable "ExecuteStep" from the parent that gives information about which tools, that needs to be executed.

BUT

The child package should be able to run independently also. In this case all tools inside the package should execute.
This is however not possible because my variable "ExecuteStep" does not exist inside the package, it is inheritage from my parent.

If I create a variable with exactly the same name inside my child package, I can run the child independently, but when executed from the parent the value from the parent package is now overwritten by the child variable.

How can I get around this problem?

bjarneThe solution was just in front of me all the time.

As "Package Configuration" I was using the XML file I had generated with the Parent variables.

Instead I should have been using "Parent package variable", this way all works fine.

I found it with a help from Kirk Haselden's blog

http://sqljunkies.com/WebLog/knight_reign/comments/5366.aspx

Bjarne

Run child package independently

Hi there

I have a parent package which execute a child package. But when the child package is run from the parent not all of the tools inside is executed. I have a variable "ExecuteStep" from the parent that gives information about which tools, that needs to be executed.

BUT

The child package should be able to run independently also. In this case all tools inside the package should execute.
This is however not possible because my variable "ExecuteStep" does not exist inside the package, it is inheritage from my parent.

If I create a variable with exactly the same name inside my child package, I can run the child independently, but when executed from the parent the value from the parent package is now overwritten by the child variable.

How can I get around this problem?

bjarneThe solution was just in front of me all the time.

As "Package Configuration" I was using the XML file I had generated with the Parent variables.

Instead I should have been using "Parent package variable", this way all works fine.

I found it with a help from Kirk Haselden's blog

http://sqljunkies.com/WebLog/knight_reign/comments/5366.aspx

Bjarne