| Author |
Saving a .bas file to SQL server as DTS
|
|
| Jaideep Mehta 2005-09-26, 7:23 am |
| How do i save a .bas file to SQL server DTS package?
I have already tried porting the bas file code to dot net and used
SQLToSave. all that works fine.
What i want to know, is there a tool available that can save a .bas file to
SQL server DTS packages?
| |
| Allan Mitchell 2005-09-26, 9:23 am |
| So I presume you saved this .bas from DTS initially?
If you look down the code you will find some liness that either execute
the package there and then or saves it back to the SQL Server.
The .bas basically builds a package from scratch.
Allan
----------------------------------------
Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com
"Jaideep Mehta" <Jaideep Mehta@discussions.microsoft.com> wrote in
message news:3831512C-7541-4090-B31D- 3DA6CED7DCB4@microso
ft.com:
> How do i save a .bas file to SQL server DTS package?
> I have already tried porting the bas file code to dot net and used
> SQLToSave. all that works fine.
>
> What i want to know, is there a tool available that can save a .bas file to
> SQL server DTS packages?
| |
| Jaideep Mehta 2005-09-26, 9:23 am |
| Thanks,
Yes i undertsand that the .bas file creates a DTS package from scratch.
I would just want to make my question clearer. The fact is that I have about
(for example) ten dts packages for which i created .bas files. Each of the
DTS packages have a UDL connection. What i want to achieve is that i want to
make the UDL location not hardcoded with in the DTS package, when i install
the dts packages i should develop the capability to choose the UDL location.
I may have UDL on C drive or D or E.
In short what i want to do is to provide the modified .bas file and save it
as a dts package.
The tool/utility should be able to take in any .bas file(originally created
out of the dts and modified) and then save this .bas file as dts on sql
server.
"Allan Mitchell" wrote:
> So I presume you saved this .bas from DTS initially?
>
> If you look down the code you will find some liness that either execute
> the package there and then or saves it back to the SQL Server.
>
> The .bas basically builds a package from scratch.
>
> Allan
>
> ----------------------------------------
> Allan Mitchell (Microsoft SQL Server MVP)
> www.SQLDTS.com
> www.SQLIS.com
> www.Konesans.com
>
>
>
>
>
>
>
> "Jaideep Mehta" <Jaideep Mehta@discussions.microsoft.com> wrote in
> message news:3831512C-7541-4090-B31D- 3DA6CED7DCB4@microso
ft.com:
>
>
>
| |
| Allan Mitchell 2005-09-27, 9:24 am |
| You do not need to distribute the package as a .bas file to do that.
You can distribute the package as a package proper (.dts) and you can
use a Dynamic Properties task to set the location or even code to do
that and you pass in the location through a variable and the /A switch
to DTSRUN
Here what I did was I set the udlPath property of the connection to be a
Global Variable and I pass in the value of the Global Variable at
RunTime.
DTSRun /S "(local)" /N "udlChangePath" /A "gv":"8"="c:\MyUdl.udl" /E
Doing it this way gives me greater flexibility.
Will this work for you?
Allan
"Jaideep Mehta" < JaideepMehta@discuss
ions.microsoft.com> wrote in
message news:96CD768F-329C-48E1-BF50- 8CBD5CDF5F2C@microso
ft.com:
[color=darkred]
> Thanks,
> Yes i undertsand that the .bas file creates a DTS package from scratch.
>
> I would just want to make my question clearer. The fact is that I have about
> (for example) ten dts packages for which i created .bas files. Each of the
> DTS packages have a UDL connection. What i want to achieve is that i want to
> make the UDL location not hardcoded with in the DTS package, when i install
> the dts packages i should develop the capability to choose the UDL location.
> I may have UDL on C drive or D or E.
>
> In short what i want to do is to provide the modified .bas file and save it
> as a dts package.
>
> The tool/utility should be able to take in any .bas file(originally created
> out of the dts and modified) and then save this .bas file as dts on sql
> server.
>
>
>
> "Allan Mitchell" wrote:
>
|
|
|
|