May 2, 2006 at 3:35 pm
Hello masters someone know if is is possible to get the dependences of a DTS? for example sp_dependDTS MyDTS , exists some SP_ ?
?
thanks any helping
May 3, 2006 at 8:58 am
I am doing this as we speak. Not knowing a better way, I converted all the packages to .BAS files (Package.Save As, then in the Save DTS Package dialog, select Visual Basic File from the Location dropdown), loaded the .BAS files to a table ,then performed queries against the table in order to populate a Dependencies table into which I already had other dependencies that can be obtained in an easier way through master.INFORMATION_SCHEMA views.
I had to convert the packages manuallly; fortunately there were only about 25. I am still looking for a way to automate this process, so that all packages can be converted with a single execution. I posted a request on this forum last week, but have not received a definite answer.
May 5, 2006 at 2:57 pm
I found a vb script that scrip out all dts into a txt file, well then i need to parse it to do a dependencies file, well i think that is the best solution.
look that it shows in my developing area of work
************************
DTS name ACTTOTAL
************************
************************
Global Variables
************************
************************
Connections
************************
************************
Tasks
************************
INSERT LOG_CARGA VALUES('INICIO CARGA',GETDATE())
TRUNCATE table [dbo].[SQLACCOUNT_NAMEINFO_T]
TRUNCATE table [dbo].[SQLACCOUNT_PHONES_T]
TRUNCATE table [dbo].[SQLACCOUNT_PRODUCTS_T]
TRUNCATE table [dbo].[SQLACCOUNT_T]
TRUNCATE table [dbo].[SQLCIUDAD]
TRUNCATE table [dbo].[SQLPLAN_T]
TRUNCATE table [dbo].[SQLPRODUCT_T]
TRUNCATE table [dbo].[SQLPROFILE1_T]
TRUNCATE table [dbo].[SQLPROFILE2_T]
TRUNCATE table [dbo].[SQLSERVICE_T]
TRUNCATE table [dbo].[SQLT_CIUDAD_COMUNAS]
TRUNCATE table [dbo].[SQLT_CODIGO_AREA]
TRUNCATE table [dbo].[SQLTCOMUNAS]
TRUNCATE table [SQLSERVICE_IP_ARGS_T]
select
account_t.POID_ID0,
account_t.ACCOUNT_NO,
account_t.BILL_TYPE,
account_t.GROUP_OBJ_ID0,
account_t.GROUP_OBJ_TYPE,
account_t.PARENT_ID0,
account_t.PARENT_TYPE,
account_t.STATUS,
fecha_inf_a_c2(account_t.LAST_STATUS_T)
from account_t
where account_t.POID_ID0
in (select account_products_t.OBJ_ID0
from account_products_t
where plan_obj_id0 not in (10089,20276)
)
SELECT 1
SELECT
OBJ_ID0,
REC_ID,
PLAN_OBJ_ID0,
PLAN_OBJ_TYPE,
PRODUCT_OBJ_ID0,
PRODUCT_OBJ_TYPE,
SERVICE_OBJ_ID0,
SERVICE_OBJ_TYPE,
STATUS
FROM ACCOUNT_PRODUCTS_T
WHERE account_products_t.plan_obj_id0 not in (10089,20276)
UPDATE SQLACCOUNT_T
SET PROCESADO = 1
WHERE SQLACCOUNT_T.POID_ID0 IN (SELECT SQLACCOUNT_PRODUCTS_T.OBJ_ID0
FROM SQLACCOUNT_PRODUCTS_T
WHERE SQLACCOUNT_PRODUCTS_T.PLAN_OBJ_ID0 IN (20276,10089)
)
EXEC CP_actualizapoidfechaperfil
select service_ip_args_t.OBJ_ID0,service_ip_args_t.REC_ID,
convert (service_ip_args_t.NAME, 'we8iso8859p1', 'utf8'),
convert (service_ip_args_t.VALUE, 'we8iso8859p1', 'utf8')
from service_ip_args_t
WHERE service_ip_args_t.OBJ_ID0 in (select distinct service_t.POID_ID0
from service_t,account_products_t
where service_t.ACCOUNT_OBJ_ID0 = account_products_t.OBJ_ID0
and account_products_t.plan_obj_id0 not in (10089,20276)
and service_t.POID_TYPE = '/service/ip'
)
SELECT
POID_ID0,
convert (POID_TYPE, 'we8iso8859p1', 'utf8'),
convert (DESCR, 'we8iso8859p1', 'utf8'),
convert (NAME, 'we8iso8859p1', 'utf8')
FROM PLAN_T
select service_t.POID_ID0,
convert (service_t.POID_TYPE, 'we8iso8859p1', 'utf8'),
service_t.ACCOUNT_OBJ_ID0,
convert (service_t.ACCOUNT_OBJ_TYPE, 'we8iso8859p1', 'utf8'),
service_t.CLOSE_WHEN_T,
convert (service_t.LASTSTAT_CMNT, 'we8iso8859p1', 'utf8'),
service_t.LAST_STATUS_T,
convert (service_t.LOGIN, 'we8iso8859p1', 'utf8'),
convert (service_t.NAME, 'we8iso8859p1', 'utf8'),
convert (service_t.PASSWD, 'we8iso8859p1', 'utf8'),
service_t.STATUS,
service_t.STATUS_FLAGS
from service_t
where service_t.ACCOUNT_OBJ_ID0 IN (SELECT account_products_t.OBJ_ID0
FROM account_products_t
WHERE account_pro
May 5, 2006 at 3:22 pm
Hector, I did not understand your post. You said that you had found a VB script that scripts out all DTS packages into a text file, but what you posted was a set of seeminly unrelated SQL statements. Did you mean to post something else?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply