Avatar of Sindibad_123
Sindibad_123

asked on 

How to know the script that populate a table from a remote db? (URGENT)

Hi, I am working on  a two different databases each one resident in a different PC, one of the db (lets call it A-2000) is on sql server 2000 contains DTS package that transfer data to the remote db(lets call it B-2008) which is on SQL 2008, now B-2008 contains a table that gets populated when the DTS on A-2000 get executed, I looked at the script of the DTS I cannot find any code that populate this table, the code in this DTS populate another tables not the one I want to know how it gets populated.
How to know where is this table get populated?
BTW I viewed the dependencies for this table but it has no dependencies at all!
I'm sure that the DTS is the one who populate this table bc whenever I execute it that table get populated.
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Anthony Perkins
ASKER CERTIFIED SOLUTION
Avatar of Gideon7
Gideon7
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Sindibad_123
Sindibad_123

ASKER

I already did that but there is no trighers
SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
Avatar of Alpesh Patel
Alpesh Patel
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Sindibad_123
Sindibad_123

ASKER

>Please check dataFlow task in DTS package
How to check the dataflow?

>Consider uploading the DTS package here.
How to scrip the entire DTS?!
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server 2008
Microsoft SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.

50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo