dbTalk Databases Forums  

Is it possible to create a stored procedure which creates dts package in SQL Server 2000?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Is it possible to create a stored procedure which creates dts package in SQL Server 2000? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ayos
 
Posts: n/a

Default Is it possible to create a stored procedure which creates dts package in SQL Server 2000? - 12-12-2005 , 08:55 AM






Hi,

I am wondering if I can create a package in SQL in SQL Server 2000.

I was thinking of creating a stored procedure which can build a dts package.

Kind regards,

Ayman



Reply With Quote
  #2  
Old   
mattb
 
Posts: n/a

Default RE: Is it possible to create a stored procedure which creates dts pack - 12-12-2005 , 03:10 PM








"ayos" wrote:

Quote:
Hi,

I am wondering if I can create a package in SQL in SQL Server 2000.

I was thinking of creating a stored procedure which can build a dts package.

Kind regards,

Ayman


Build te dts package, but push vars into it to run.
http://www.databasejournal.com/featu...le.php/1459181
Quote:

Reply With Quote
  #3  
Old   
ayos
 
Posts: n/a

Default Re: Is it possible to create a stored procedure which creates dts pack - 12-13-2005 , 04:13 AM



Hi again,

Thanks for the link but I was more thinking of building the dts package from
scratch.

Kind regards,

Ayman

"mattb" <mattb (AT) discussions (DOT) microsoft.com> wrote

Quote:

"ayos" wrote:

Hi,

I am wondering if I can create a package in SQL in SQL Server 2000.

I was thinking of creating a stored procedure which can build a dts
package.

Kind regards,

Ayman



Build te dts package, but push vars into it to run.
http://www.databasejournal.com/featu...le.php/1459181




Reply With Quote
  #4  
Old   
mattb
 
Posts: n/a

Default Re: Is it possible to create a stored procedure which creates dts - 12-13-2005 , 03:41 PM





"ayos" wrote:

Quote:
Hi again,

Thanks for the link but I was more thinking of building the dts package from
scratch.

Kind regards,

Ayman

"mattb" <mattb (AT) discussions (DOT) microsoft.com> wrote in message
news:B5384493-C8F8-42FE-A133-1A05B3964EC7 (AT) microsoft (DOT) com...


"ayos" wrote:

Hi,

I am wondering if I can create a package in SQL in SQL Server 2000.

I was thinking of creating a stored procedure which can build a dts
package.

Kind regards,

Ayman



Build te dts package, but push vars into it to run.
http://www.databasejournal.com/featu...le.php/1459181




Not 100% positive, but probably cannot be done. curious as to why though ?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.