I have a C# app that loads and runs a DTS package. It works great on my dev system but when I move it to the production system (which has SQL Server 2000 installed) it doesn't work. As soon as my app runs, it throws the exception:
"File or assembly name Interop.DTS, or one of its dependencies, was not found."
I've manually done: "regsvr32 dtspkg.dll" which succeeds but doesn't fix the problem.
Any ideas?Nevermind, I figured it out. DTS is a COM object and .NET generates a glue DLL: "Interop.DTS.dll".
I just needed to copy this DLL as well as my .exe
cool...|||Yeah!
Showing posts with label system. Show all posts
Showing posts with label system. Show all posts
Thursday, March 29, 2012
DTS file name to include System Date/Time
We have an application group that wants to pull date from SQL Server and write it to text file on the server. They want the file format to be 12100_YYYMMDDHHMM.fr1 for one set of data, 12100_YYYMMDDHHMM.fr2 for a second set...and so on. The '12100' is fixed, but the rest of the file name will always have to include the system date/time. Is there an easy way to do this within a DTS package (when writing to the output file)?
I would really appreciate help on this. Thank you.Hi
You can set a global variable to the fixed part at the start of the process. This should help http://www.sqldts.com/default.aspx?200 although you want to set a global variable rather than a local one.
John
"steven virnig" <pezguy@.mn.rr.com> wrote in message news:o1ovd.114089$ye4.34831@.twister.rdc-kc.rr.com...
We have an application group that wants to pull date from SQL Server and write it to text file on the server. They want the file format to be 12100_YYYMMDDHHMM.fr1 for one set of data, 12100_YYYMMDDHHMM.fr2 for a second set...and so on. The '12100' is fixed, but the rest of the file name will always have to include the system date/time. Is there an easy way to do this within a DTS package (when writing to the output file)?
I would really appreciate help on this. Thank you.
Sunday, March 25, 2012
DTS Error checking
Hello,
What would be good syntax to add to a DTS package to make sure that all of
the records from a live system made it into a warehouse table? Would it be
as simple as a COUNT(*) - and if so, how would I use that to notify or fail
if all of the records do not make it into the warehouse?
Thanks!Something like count would suffice but is not necessary. The dts either take
s
all the rows or it does not. How you log what fails is more importante. See
step2.
If I was working with a datawarehouse i would seriously entertain the idea
of a rock solid logging system. Here are some guidelines that could work for
y0ou.
Step1: For each transformation Step in the DTS, have an 'On Success' & 'On
Fail' workflow. The Success could goto a SQL Task and do a count and log
through a sProc For eg:
EXEC sp_lo_insert_DTSlog ?, 'DTSEXECUTESTEPS', 'STATUS', 'DTS Package :
DTSName Completed Successfully'
If successgul the DTS will execute the next transformation step in the
sequence and the failure would execute an ActiveX Script Task.(see step2)
Step2: ActiveX Script Named Fail Step1
Function Main()
Dim oPackage
Set oPackage = DTSGlobalVariables.Parent
DTSGlobalVariables("gvPkgStatusDesc").Value = "ERROR : DTS Package " &
DTSGlobalVariables("gvPackageName").Value & _
" - Failed to load STAGING table TableName"
oPackage.Steps("DTSStep_DTSExecuteSQLTask_1").DisableStep = 0
Set oPackage = Nothing
Main = DTSTaskExecResult_Success
End Function
All you need is on http://www.sqldts.com/
What would be good syntax to add to a DTS package to make sure that all of
the records from a live system made it into a warehouse table? Would it be
as simple as a COUNT(*) - and if so, how would I use that to notify or fail
if all of the records do not make it into the warehouse?
Thanks!Something like count would suffice but is not necessary. The dts either take
s
all the rows or it does not. How you log what fails is more importante. See
step2.
If I was working with a datawarehouse i would seriously entertain the idea
of a rock solid logging system. Here are some guidelines that could work for
y0ou.
Step1: For each transformation Step in the DTS, have an 'On Success' & 'On
Fail' workflow. The Success could goto a SQL Task and do a count and log
through a sProc For eg:
EXEC sp_lo_insert_DTSlog ?, 'DTSEXECUTESTEPS', 'STATUS', 'DTS Package :
DTSName Completed Successfully'
If successgul the DTS will execute the next transformation step in the
sequence and the failure would execute an ActiveX Script Task.(see step2)
Step2: ActiveX Script Named Fail Step1
Function Main()
Dim oPackage
Set oPackage = DTSGlobalVariables.Parent
DTSGlobalVariables("gvPkgStatusDesc").Value = "ERROR : DTS Package " &
DTSGlobalVariables("gvPackageName").Value & _
" - Failed to load STAGING table TableName"
oPackage.Steps("DTSStep_DTSExecuteSQLTask_1").DisableStep = 0
Set oPackage = Nothing
Main = DTSTaskExecResult_Success
End Function
All you need is on http://www.sqldts.com/
Thursday, March 22, 2012
DTS Error
I am trying to run a scheduled package in the DTS and keep getting a the error message in the job history:
'Executed as user: UTSQL01\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step DTSRun OnError: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.'
Is there someone that knows what this means and how I can correct it?
Thanks.I'm assuming that when you run it manually it works...
It sounds like a security issue...the sql agent account needs permission
Yes?|||It is a security issue. I can't seem to get around it though. I log on as administrator and I get a whole new set of errors. I am now trying to export to Excel and get the error that the path to the Excel sheet is wrong. How do I give permissions?
Thanks.|||This should answer your question:
link (http://support.microsoft.com/?id=269074)
Let me know if you still have the problem.|||I can't change the owner info in the Owner drop-down combo box which is what it tells me to do.
Thanks for your help. The link you sent was the right one.|||Are you stuck ... ?|||Very. How can I change the owner?|||What happens when you change the owner and select apply ? Do you have administrator rights ?|||The owner combobox is grayed and I can't even access it.|||Do you have sys admin access ? Can you login as the owner ?|||You can also try the stored procedure to change the ownership:
sp_update_job|||I can't run it for some reason. I don't know much about this stuff.|||Try msdb.dbo.sp_update_job ... What is your access level in sql server ? Have you tried logging in as sa ?|||I can run the procedure in Query Analyzer but I get the message:
Server: Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 24
Supply either @.job_id or @.job_name to identify the job.
Stored Procedure: msdb.dbo.sp_update_job
Return Code = 1
Where do I put the job_id or job_name?
Thanks again for your help.|||The job now says it succeeded but when I open the destination file, there is no data there. I'm lost.
And I ran the procedure msdb.dbo.sp_update_job and got a:
Stored Procedure: msdb.dbo.sp_update_job
Return Code = 0
message.|||Did you get the sp to execute ? What is the destination file ? What happens when you execute the dts manually - does the destination file contain something ?|||Manually it works fine. And I did run the SP.|||Can you break down what the dts is doing (step-by-step) and what is supposed to be in the file ?|||When I export to Excel on my desktop I get:
Executed as user: UTSQL01\SYSTEM. ...art: Drop table PROFORM1099 Step DTSRun OnFinish: Drop table PROFORM1099 Step DTSRun OnStart: Create Table PROFORM1099 Step DTSRun OnFinish: Create Table PROFORM1099 Step DTSRun OnStart: Copy Data from ProForm1099 to PROFORM1099 Step DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step... Process Exit Code 0. The step succeeded.
Everything worked, but there is no data in the destination file.
If I try to export to an Excel sheet on my C:\ drive I get an error that the path is incorrect and to check it again.
There is nothing major in the source table. Just 4 columns with 15000 rows of num,and char strings.|||Was that last one scheduled?
If it was, it's on the server...
What happens when you use the export wizard?
What's the data destination in the transformation?
Betcha it's on the server...can you map to it?|||I don't understand what you mean if the last one was scheduled. I always use the export wizard. The destination is an Excel sheet on my desktop. I can map to it.|||When you execute dts using enterprise manager from your desktop, the file will appear on your local drive (if that is where the destination is located - for example c:\). When you execute the dts as a job, it will execute on the server - so the file should be on the server (not your desktop).
Let me know if this is what happened.|||It looks like the file was saved on the server. How can I get it to save on my local machine?
Thanks again.|||You can do the following:
\\computername\c$\file.txt - assuming permissions are ok.
Rather than the server pushing to your machine - I would recommend pulling the file from the server.
'Executed as user: UTSQL01\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step DTSRun OnError: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.'
Is there someone that knows what this means and how I can correct it?
Thanks.I'm assuming that when you run it manually it works...
It sounds like a security issue...the sql agent account needs permission
Yes?|||It is a security issue. I can't seem to get around it though. I log on as administrator and I get a whole new set of errors. I am now trying to export to Excel and get the error that the path to the Excel sheet is wrong. How do I give permissions?
Thanks.|||This should answer your question:
link (http://support.microsoft.com/?id=269074)
Let me know if you still have the problem.|||I can't change the owner info in the Owner drop-down combo box which is what it tells me to do.
Thanks for your help. The link you sent was the right one.|||Are you stuck ... ?|||Very. How can I change the owner?|||What happens when you change the owner and select apply ? Do you have administrator rights ?|||The owner combobox is grayed and I can't even access it.|||Do you have sys admin access ? Can you login as the owner ?|||You can also try the stored procedure to change the ownership:
sp_update_job|||I can't run it for some reason. I don't know much about this stuff.|||Try msdb.dbo.sp_update_job ... What is your access level in sql server ? Have you tried logging in as sa ?|||I can run the procedure in Query Analyzer but I get the message:
Server: Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 24
Supply either @.job_id or @.job_name to identify the job.
Stored Procedure: msdb.dbo.sp_update_job
Return Code = 1
Where do I put the job_id or job_name?
Thanks again for your help.|||The job now says it succeeded but when I open the destination file, there is no data there. I'm lost.
And I ran the procedure msdb.dbo.sp_update_job and got a:
Stored Procedure: msdb.dbo.sp_update_job
Return Code = 0
message.|||Did you get the sp to execute ? What is the destination file ? What happens when you execute the dts manually - does the destination file contain something ?|||Manually it works fine. And I did run the SP.|||Can you break down what the dts is doing (step-by-step) and what is supposed to be in the file ?|||When I export to Excel on my desktop I get:
Executed as user: UTSQL01\SYSTEM. ...art: Drop table PROFORM1099 Step DTSRun OnFinish: Drop table PROFORM1099 Step DTSRun OnStart: Create Table PROFORM1099 Step DTSRun OnFinish: Create Table PROFORM1099 Step DTSRun OnStart: Copy Data from ProForm1099 to PROFORM1099 Step DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step... Process Exit Code 0. The step succeeded.
Everything worked, but there is no data in the destination file.
If I try to export to an Excel sheet on my C:\ drive I get an error that the path is incorrect and to check it again.
There is nothing major in the source table. Just 4 columns with 15000 rows of num,and char strings.|||Was that last one scheduled?
If it was, it's on the server...
What happens when you use the export wizard?
What's the data destination in the transformation?
Betcha it's on the server...can you map to it?|||I don't understand what you mean if the last one was scheduled. I always use the export wizard. The destination is an Excel sheet on my desktop. I can map to it.|||When you execute dts using enterprise manager from your desktop, the file will appear on your local drive (if that is where the destination is located - for example c:\). When you execute the dts as a job, it will execute on the server - so the file should be on the server (not your desktop).
Let me know if this is what happened.|||It looks like the file was saved on the server. How can I get it to save on my local machine?
Thanks again.|||You can do the following:
\\computername\c$\file.txt - assuming permissions are ok.
Rather than the server pushing to your machine - I would recommend pulling the file from the server.
DTS Designer error
when I open a DTS package (or create a new one) I get the error:
DTS Designer error
The system cannot find the file specified
then the package opens, but there are no objects in the "tasks" pane (the
"connection" pane looks ok). All the task objects in the package show up
though (and can be edited too) but no new ones can be added (since also under
the Task menu, only the items "Register custom task..." and "Unregister
custom task..." exist).
So the question is: which dlls are the missing tasks so that to register
them back?
Also, any ideas why they dissapeared?
It's generally from having a mix of different service pack
levels. See the following article:
Service Pack and Version Compatibility Problems
http://www.sqldts.com/default.aspx?223
-Sue
On Wed, 25 Jan 2006 02:13:02 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
>when I open a DTS package (or create a new one) I get the error:
>DTS Designer error
>The system cannot find the file specified
>then the package opens, but there are no objects in the "tasks" pane (the
>"connection" pane looks ok). All the task objects in the package show up
>though (and can be edited too) but no new ones can be added (since also under
>the Task menu, only the items "Register custom task..." and "Unregister
>custom task..." exist).
>So the question is: which dlls are the missing tasks so that to register
>them back?
>Also, any ideas why they dissapeared?
|||It didnt work. I checked both
http://www.sqldts.com/default.aspx?223 and the related link
http://support.microsoft.com/Default.aspx?kbid=274716
but they all seem to refer to SQL Server 7.0 issues.
I have SQL 2000 SP4 (both on the server and the client tools in my pc) and
the packages were created with this version.
"Sue Hoegemeier" wrote:
> It's generally from having a mix of different service pack
> levels. See the following article:
> Service Pack and Version Compatibility Problems
> http://www.sqldts.com/default.aspx?223
> -Sue
>
|||Try opening the packages from another box. If you can open
them fine on other boxes then it's specific to that box. You
could first try reregistering dtsui.dll. Other than that,
they rest are listed in the following:
http://www.sqldts.com/default.aspx?225
-Sue
On Thu, 26 Jan 2006 03:31:02 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>It didnt work. I checked both
>http://www.sqldts.com/default.aspx?223 and the related link
>http://support.microsoft.com/Default.aspx?kbid=274716
>but they all seem to refer to SQL Server 7.0 issues.
>I have SQL 2000 SP4 (both on the server and the client tools in my pc) and
>the packages were created with this version.
>
>"Sue Hoegemeier" wrote:
|||Oh yes, I forgot to mention that: The problem is ONLY on my pc. When I open
the packages from the Enterprise Manager on the server, or any other pc with
the client tools, everything is ok.
The dlls listed in the link (and also the ones in the redistr.txt of SP4)
are not the missing tools of the DTS Designer, they seem to only contain
supporting code to run DTS packages from other applications (including the EM
itself). I register them, but nothing changes on the interface.
I have also re-installed the client tools and re-applied SP4, but still
nothing.
"Sue Hoegemeier" wrote:
> Try opening the packages from another box. If you can open
> them fine on other boxes then it's specific to that box. You
> could first try reregistering dtsui.dll. Other than that,
> they rest are listed in the following:
> http://www.sqldts.com/default.aspx?225
> -Sue
|||Additionally, here are some other people with the same problem (none got any
lucky):
http://groups.google.com/group/micro...0e3c34fa5a0 9
http://groups.google.com/group/micro...d930f85a8ba 3
http://groups.google.com/group/micro...40731b4429b a
|||I know others have reported similar issues.
I believe Dtsui has the icons.
Only other thing I can think of to try is reapplying the
last service pack on your PC.
-Sue
On Fri, 27 Jan 2006 01:16:02 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
>Additionally, here are some other people with the same problem (none got any
>lucky):
>http://groups.google.com/group/micro...0e3c34fa5a0 9
>http://groups.google.com/group/micro...d930f85a8ba 3
>http://groups.google.com/group/micro...40731b4429b a
|||I'm having this issue but slightly different situation. When I create a new DTS package or edit an existing package I get a messagebox "DTS Designer Error" with text "Access is denied." The twist is that this only happens to me when I log in to windows as a user joined to a domain. When I log in to windows as the local administrator everything works correctly.
Obviously it has to do with permissions, but whats odd is that I have added the domain user to the (local) Administrators group specifically to *have* unrestricted rights to my machine. Somehow, in this particular instance, it seems EM is attempting to list the DTS tasks installed in a way that windows,domain security,group policies are disallowing.
AFAIK, the dts tasks are enumerated in the registry. So I don't understand how file permissions could play a role.sql
DTS Designer error
The system cannot find the file specified
then the package opens, but there are no objects in the "tasks" pane (the
"connection" pane looks ok). All the task objects in the package show up
though (and can be edited too) but no new ones can be added (since also under
the Task menu, only the items "Register custom task..." and "Unregister
custom task..." exist).
So the question is: which dlls are the missing tasks so that to register
them back?
Also, any ideas why they dissapeared?
It's generally from having a mix of different service pack
levels. See the following article:
Service Pack and Version Compatibility Problems
http://www.sqldts.com/default.aspx?223
-Sue
On Wed, 25 Jan 2006 02:13:02 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
>when I open a DTS package (or create a new one) I get the error:
>DTS Designer error
>The system cannot find the file specified
>then the package opens, but there are no objects in the "tasks" pane (the
>"connection" pane looks ok). All the task objects in the package show up
>though (and can be edited too) but no new ones can be added (since also under
>the Task menu, only the items "Register custom task..." and "Unregister
>custom task..." exist).
>So the question is: which dlls are the missing tasks so that to register
>them back?
>Also, any ideas why they dissapeared?
|||It didnt work. I checked both
http://www.sqldts.com/default.aspx?223 and the related link
http://support.microsoft.com/Default.aspx?kbid=274716
but they all seem to refer to SQL Server 7.0 issues.
I have SQL 2000 SP4 (both on the server and the client tools in my pc) and
the packages were created with this version.
"Sue Hoegemeier" wrote:
> It's generally from having a mix of different service pack
> levels. See the following article:
> Service Pack and Version Compatibility Problems
> http://www.sqldts.com/default.aspx?223
> -Sue
>
|||Try opening the packages from another box. If you can open
them fine on other boxes then it's specific to that box. You
could first try reregistering dtsui.dll. Other than that,
they rest are listed in the following:
http://www.sqldts.com/default.aspx?225
-Sue
On Thu, 26 Jan 2006 03:31:02 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>It didnt work. I checked both
>http://www.sqldts.com/default.aspx?223 and the related link
>http://support.microsoft.com/Default.aspx?kbid=274716
>but they all seem to refer to SQL Server 7.0 issues.
>I have SQL 2000 SP4 (both on the server and the client tools in my pc) and
>the packages were created with this version.
>
>"Sue Hoegemeier" wrote:
|||Oh yes, I forgot to mention that: The problem is ONLY on my pc. When I open
the packages from the Enterprise Manager on the server, or any other pc with
the client tools, everything is ok.
The dlls listed in the link (and also the ones in the redistr.txt of SP4)
are not the missing tools of the DTS Designer, they seem to only contain
supporting code to run DTS packages from other applications (including the EM
itself). I register them, but nothing changes on the interface.
I have also re-installed the client tools and re-applied SP4, but still
nothing.
"Sue Hoegemeier" wrote:
> Try opening the packages from another box. If you can open
> them fine on other boxes then it's specific to that box. You
> could first try reregistering dtsui.dll. Other than that,
> they rest are listed in the following:
> http://www.sqldts.com/default.aspx?225
> -Sue
|||Additionally, here are some other people with the same problem (none got any
lucky):
http://groups.google.com/group/micro...0e3c34fa5a0 9
http://groups.google.com/group/micro...d930f85a8ba 3
http://groups.google.com/group/micro...40731b4429b a
|||I know others have reported similar issues.
I believe Dtsui has the icons.
Only other thing I can think of to try is reapplying the
last service pack on your PC.
-Sue
On Fri, 27 Jan 2006 01:16:02 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
>Additionally, here are some other people with the same problem (none got any
>lucky):
>http://groups.google.com/group/micro...0e3c34fa5a0 9
>http://groups.google.com/group/micro...d930f85a8ba 3
>http://groups.google.com/group/micro...40731b4429b a
|||I'm having this issue but slightly different situation. When I create a new DTS package or edit an existing package I get a messagebox "DTS Designer Error" with text "Access is denied." The twist is that this only happens to me when I log in to windows as a user joined to a domain. When I log in to windows as the local administrator everything works correctly.
Obviously it has to do with permissions, but whats odd is that I have added the domain user to the (local) Administrators group specifically to *have* unrestricted rights to my machine. Somehow, in this particular instance, it seems EM is attempting to list the DTS tasks installed in a way that windows,domain security,group policies are disallowing.
AFAIK, the dts tasks are enumerated in the registry. So I don't understand how file permissions could play a role.sql
Monday, March 19, 2012
DTS and processing order
I have a set up DTS packages that I have set up to run every night.
Each package copys a table from a foreign database to our SQL Server
2000 system.
There are about 60 packages and some of the files have over half a
million records and take a little time. I have a package that calls all
of these as sub tasks. Is there a problem with just letting them run -
with no precedence constraints set.?
I have heard that you shouldn't run more that about 4 packages or so
packages at a time in parallel. If this is the case, do I have to set
them up one after another serially?
Also, if I have a one processer system, will running them in parallel
help me at all?
Thanks,
Tom.Hi Tom,
There should not be any problems executing multiple Packages at the same
time.
SQL Server would process the individual tasks appropriately, It would not
start processing more packages, then what it can handle, depending upon the
available resources.
Regarding precedence of the packages : This mainly depends upon the design
of your database. If you have defined constraints on the tables, for which
you are importing the data, then you may have to keep the constraints in
mind and then set the precedence for importing the data. So that the import
process of the dependent table does not fail, due to non availability of
the records in the master table.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Each package copys a table from a foreign database to our SQL Server
2000 system.
There are about 60 packages and some of the files have over half a
million records and take a little time. I have a package that calls all
of these as sub tasks. Is there a problem with just letting them run -
with no precedence constraints set.?
I have heard that you shouldn't run more that about 4 packages or so
packages at a time in parallel. If this is the case, do I have to set
them up one after another serially?
Also, if I have a one processer system, will running them in parallel
help me at all?
Thanks,
Tom.Hi Tom,
There should not be any problems executing multiple Packages at the same
time.
SQL Server would process the individual tasks appropriately, It would not
start processing more packages, then what it can handle, depending upon the
available resources.
Regarding precedence of the packages : This mainly depends upon the design
of your database. If you have defined constraints on the tables, for which
you are importing the data, then you may have to keep the constraints in
mind and then set the precedence for importing the data. So that the import
process of the dependent table does not fail, due to non availability of
the records in the master table.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Sunday, March 11, 2012
DTS and decimal issue
I am importing a table from our ERP system using a DTS. THe table imports fine. The only issue that I am having is that a decimal field in our ERP system can be for example 105.1275, but when it gets inported to sql the number is 105.1270.
What could possibly be the issue and sollution for this. All help is appreciated.Ummm... what's the source platform of the data and the destination platform?
That'll learn you for using DT...uh...I can't say it...
Did you look at the transformation? Waht's the DDL of the source and destination look like?|||Check that the precision/length settings for the destination field is correct.
What could possibly be the issue and sollution for this. All help is appreciated.Ummm... what's the source platform of the data and the destination platform?
That'll learn you for using DT...uh...I can't say it...
Did you look at the transformation? Waht's the DDL of the source and destination look like?|||Check that the precision/length settings for the destination field is correct.
Friday, March 9, 2012
DTS 2000 on 64 Bit
Hi,
I have certain DTS 2000 jobs which have to br run on a 64 bit system after upgradation. Is this possible
Manish
Moving to the IS forum, where you're more likely to get a response.
Paul
|||yes, I suggest reading from the following topic from SQL Books Online.
"Integration Services Considerations on 64-bit Computers "
DTS 2000 on 64 Bit
Hi,
I have certain DTS 2000 jobs which have to br run on a 64 bit system after upgradation. Is this possible
Manish
Moving to the IS forum, where you're more likely to get a response.
Paul
|||yes, I suggest reading from the following topic from SQL Books Online.
"Integration Services Considerations on 64-bit Computers "
Friday, February 24, 2012
dtproperties system table changed to user table in sysobjects?
Hi Gurus,
I occasionally use some T-SQL to add a column or trigger to all usertables t
ables within a database.
It has always worked before but on one database I am having a problem becaus
e the "dtproperties" system table appears to have been changed to a user tab
le in the "sysobjects" table and is being returned in along with all the use
rtables by:
select [name] from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1
I can skip that table easily enough, but can anyone tell me why this may ha
ve changed and if I should change it back to a system table, if so how would
I go about that?
Regards,
Pauldtproperties is created when you create a database diagram. It is marked as
a user table by default so I suggest you exclude it by name in your script.
David Portas
SQL Server MVP
--
"Paul B" <paul.bunting@.archsoftnet.com> wrote in message
news:%234h2UcmxFHA.2728@.TK2MSFTNGP14.phx.gbl...
Hi Gurus,
I occasionally use some T-SQL to add a column or trigger to all usertables
tables within a database.
It has always worked before but on one database I am having a problem
because the "dtproperties" system table appears to have been changed to a
user table in the "sysobjects" table and is being returned in along with all
the usertables by:
select [name] from dbo.sysobjects where OBJECTPROPERTY(id,
N'IsUserTable') = 1
I can skip that table easily enough, but can anyone tell me why this may
have changed and if I should change it back to a system table, if so how
would I go about that?
Regards,
Paul|||... or also use IsMsShipped:
select [name]
from dbo.sysobjects
where OBJECTPROPERTY(id, N'IsUserTable') = 1
AND OBJECTPROPERTY(id, N'IsMSShipped') = 0
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:2f2dnarVIKxH5aPenZ2dnUVZ8t2dnZ2d@.gi
ganews.com...
> dtproperties is created when you create a database diagram. It is marked a
s a user table by
> default so I suggest you exclude it by name in your script.
> --
> David Portas
> SQL Server MVP
> --
> "Paul B" <paul.bunting@.archsoftnet.com> wrote in message
> news:%234h2UcmxFHA.2728@.TK2MSFTNGP14.phx.gbl...
> Hi Gurus,
> I occasionally use some T-SQL to add a column or trigger to all usertables
tables within a
> database.
> It has always worked before but on one database I am having a problem beca
use the "dtproperties"
> system table appears to have been changed to a user table in the "sysobjec
ts" table and is being
> returned in along with all the usertables by:
> select [name] from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable'
) = 1
> I can skip that table easily enough, but can anyone tell me why this may
have changed and if I
> should change it back to a system table, if so how would I go about that?
> Regards,
> Paul
>|||Thanks,
Was a bit puzzled as to the fact that it was shown as a system table by
Enterprise Manager and returned as a user table by "where
OBJECTPROPERTY(id, N'IsUserTable') = 1".
David mentioned it is added when you create a database diagram, is this
always the case?... the database I had the error did not have any diagrams
and never has (it was only created a couple of days ago), and a duplicate
database created at the same time returned "dtproperties" as a system table!
I had included an if statment to exclude that table, will probably switch it
to "OBJECTPROPERTY(id, N'IsMSShipped')" as suggested by Tibor... is there
any other tables that could be both system and user at the same time that
this problem may occur with?
Regards,
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eW7LtgpxFHA.2540@.TK2MSFTNGP09.phx.gbl...
> ... or also use IsMsShipped:
> select [name]
> from dbo.sysobjects
> where OBJECTPROPERTY(id, N'IsUserTable') = 1
> AND OBJECTPROPERTY(id, N'IsMSShipped') = 0
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:2f2dnarVIKxH5aPenZ2dnUVZ8t2dnZ2d@.gi
ganews.com...
>|||EM is hard-wired to show dtproperties as a system table... The table might b
e created by other EM
GUI elements, like the design table dialog etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul B" <paul.no-email-please.bunting@.archsoftnet.com> wrote in message
news:Oduh6AsxFHA.2848@.TK2MSFTNGP15.phx.gbl...
> Thanks,
> Was a bit puzzled as to the fact that it was shown as a system table by En
terprise Manager and
> returned as a user table by "where OBJECTPROPERTY(id, N'IsUserTable') = 1
".
> David mentioned it is added when you create a database diagram, is this al
ways the case?... the
> database I had the error did not have any diagrams and never has (it was o
nly created a couple of
> days ago), and a duplicate database created at the same time returned "dtp
roperties" as a system
> table!
> I had included an if statment to exclude that table, will probably switch
it to
> "OBJECTPROPERTY(id, N'IsMSShipped')" as suggested by Tibor... is there any
other tables that could
> be both system and user at the same time that this problem may occur with?
> Regards,
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:eW7LtgpxFHA.2540@.TK2MSFTNGP09.phx.gbl...
>
I occasionally use some T-SQL to add a column or trigger to all usertables t
ables within a database.
It has always worked before but on one database I am having a problem becaus
e the "dtproperties" system table appears to have been changed to a user tab
le in the "sysobjects" table and is being returned in along with all the use
rtables by:
select [name] from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1
I can skip that table easily enough, but can anyone tell me why this may ha
ve changed and if I should change it back to a system table, if so how would
I go about that?
Regards,
Pauldtproperties is created when you create a database diagram. It is marked as
a user table by default so I suggest you exclude it by name in your script.
David Portas
SQL Server MVP
--
"Paul B" <paul.bunting@.archsoftnet.com> wrote in message
news:%234h2UcmxFHA.2728@.TK2MSFTNGP14.phx.gbl...
Hi Gurus,
I occasionally use some T-SQL to add a column or trigger to all usertables
tables within a database.
It has always worked before but on one database I am having a problem
because the "dtproperties" system table appears to have been changed to a
user table in the "sysobjects" table and is being returned in along with all
the usertables by:
select [name] from dbo.sysobjects where OBJECTPROPERTY(id,
N'IsUserTable') = 1
I can skip that table easily enough, but can anyone tell me why this may
have changed and if I should change it back to a system table, if so how
would I go about that?
Regards,
Paul|||... or also use IsMsShipped:
select [name]
from dbo.sysobjects
where OBJECTPROPERTY(id, N'IsUserTable') = 1
AND OBJECTPROPERTY(id, N'IsMSShipped') = 0
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:2f2dnarVIKxH5aPenZ2dnUVZ8t2dnZ2d@.gi
ganews.com...
> dtproperties is created when you create a database diagram. It is marked a
s a user table by
> default so I suggest you exclude it by name in your script.
> --
> David Portas
> SQL Server MVP
> --
> "Paul B" <paul.bunting@.archsoftnet.com> wrote in message
> news:%234h2UcmxFHA.2728@.TK2MSFTNGP14.phx.gbl...
> Hi Gurus,
> I occasionally use some T-SQL to add a column or trigger to all usertables
tables within a
> database.
> It has always worked before but on one database I am having a problem beca
use the "dtproperties"
> system table appears to have been changed to a user table in the "sysobjec
ts" table and is being
> returned in along with all the usertables by:
> select [name] from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable'
) = 1
> I can skip that table easily enough, but can anyone tell me why this may
have changed and if I
> should change it back to a system table, if so how would I go about that?
> Regards,
> Paul
>|||Thanks,
Was a bit puzzled as to the fact that it was shown as a system table by
Enterprise Manager and returned as a user table by "where
OBJECTPROPERTY(id, N'IsUserTable') = 1".
David mentioned it is added when you create a database diagram, is this
always the case?... the database I had the error did not have any diagrams
and never has (it was only created a couple of days ago), and a duplicate
database created at the same time returned "dtproperties" as a system table!
I had included an if statment to exclude that table, will probably switch it
to "OBJECTPROPERTY(id, N'IsMSShipped')" as suggested by Tibor... is there
any other tables that could be both system and user at the same time that
this problem may occur with?
Regards,
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eW7LtgpxFHA.2540@.TK2MSFTNGP09.phx.gbl...
> ... or also use IsMsShipped:
> select [name]
> from dbo.sysobjects
> where OBJECTPROPERTY(id, N'IsUserTable') = 1
> AND OBJECTPROPERTY(id, N'IsMSShipped') = 0
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:2f2dnarVIKxH5aPenZ2dnUVZ8t2dnZ2d@.gi
ganews.com...
>|||EM is hard-wired to show dtproperties as a system table... The table might b
e created by other EM
GUI elements, like the design table dialog etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul B" <paul.no-email-please.bunting@.archsoftnet.com> wrote in message
news:Oduh6AsxFHA.2848@.TK2MSFTNGP15.phx.gbl...
> Thanks,
> Was a bit puzzled as to the fact that it was shown as a system table by En
terprise Manager and
> returned as a user table by "where OBJECTPROPERTY(id, N'IsUserTable') = 1
".
> David mentioned it is added when you create a database diagram, is this al
ways the case?... the
> database I had the error did not have any diagrams and never has (it was o
nly created a couple of
> days ago), and a duplicate database created at the same time returned "dtp
roperties" as a system
> table!
> I had included an if statment to exclude that table, will probably switch
it to
> "OBJECTPROPERTY(id, N'IsMSShipped')" as suggested by Tibor... is there any
other tables that could
> be both system and user at the same time that this problem may occur with?
> Regards,
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:eW7LtgpxFHA.2540@.TK2MSFTNGP09.phx.gbl...
>
dtproperties
What is the purpose of the table dtproperties? It is a system table but has
xtype = 'U' in the sysobjects table?
It's not really a system table but it's displayed as such by
Enterprise Manager. The table is used for diagrams you
create through Enterprise Manager.
-Sue
On Thu, 14 Jul 2005 16:15:29 -0700, "docsql"
<docsql@.noemail.nospam> wrote:
>What is the purpose of the table dtproperties? It is a system table but has
>xtype = 'U' in the sysobjects table?
>
xtype = 'U' in the sysobjects table?
It's not really a system table but it's displayed as such by
Enterprise Manager. The table is used for diagrams you
create through Enterprise Manager.
-Sue
On Thu, 14 Jul 2005 16:15:29 -0700, "docsql"
<docsql@.noemail.nospam> wrote:
>What is the purpose of the table dtproperties? It is a system table but has
>xtype = 'U' in the sysobjects table?
>
dtproperties
What is the purpose of the table dtproperties? It is a system table but has
xtype = 'U' in the sysobjects table?It's not really a system table but it's displayed as such by
Enterprise Manager. The table is used for diagrams you
create through Enterprise Manager.
-Sue
On Thu, 14 Jul 2005 16:15:29 -0700, "docsql"
<docsql@.noemail.nospam> wrote:
>What is the purpose of the table dtproperties? It is a system table but has
>xtype = 'U' in the sysobjects table?
>
xtype = 'U' in the sysobjects table?It's not really a system table but it's displayed as such by
Enterprise Manager. The table is used for diagrams you
create through Enterprise Manager.
-Sue
On Thu, 14 Jul 2005 16:15:29 -0700, "docsql"
<docsql@.noemail.nospam> wrote:
>What is the purpose of the table dtproperties? It is a system table but has
>xtype = 'U' in the sysobjects table?
>
dtproperties
What is the purpose of the table dtproperties? It is a system table but has
xtype = 'U' in the sysobjects table?It's not really a system table but it's displayed as such by
Enterprise Manager. The table is used for diagrams you
create through Enterprise Manager.
-Sue
On Thu, 14 Jul 2005 16:15:29 -0700, "docsql"
<docsql@.noemail.nospam> wrote:
>What is the purpose of the table dtproperties? It is a system table but ha
s
>xtype = 'U' in the sysobjects table?
>
xtype = 'U' in the sysobjects table?It's not really a system table but it's displayed as such by
Enterprise Manager. The table is used for diagrams you
create through Enterprise Manager.
-Sue
On Thu, 14 Jul 2005 16:15:29 -0700, "docsql"
<docsql@.noemail.nospam> wrote:
>What is the purpose of the table dtproperties? It is a system table but ha
s
>xtype = 'U' in the sysobjects table?
>
Friday, February 17, 2012
DTC and firewalls
We have a requirement to utilize MS-DTC from internet facing to an internal
system running SQL Server 2000. Can the DTC be stand alone on a dedicated
server in the external environment and then contact the SQL database through
a specific port? Is this technically possible? Any security implications?Alexis wrote:
> We have a requirement to utilize MS-DTC from internet facing to an internal
> system running SQL Server 2000. Can the DTC be stand alone on a dedicated
> server in the external environment and then contact the SQL database through
> a specific port?
Yes.
> Is this technically possible?
Yes.
> Any security implications?
DTS is a usual SQL Server Client application. All the security
implications are based on this fact.|||Yura, perhaps you misread DTC as DTS. DTC, AFAIK, speaks only RPC which probably makes it tricky
with firewalls (I'm not network expert...). I'm fairly certain that I've read a KB about this,
should be relatively easy to find.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Yura Shalak" <yuras@.nospam.nospam> wrote in message news:up%23UoeohHHA.1456@.TK2MSFTNGP04.phx.gbl...
> Alexis wrote:
>> We have a requirement to utilize MS-DTC from internet facing to an internal system running SQL
>> Server 2000. Can the DTC be stand alone on a dedicated server in the external environment and
>> then contact the SQL database through a specific port?
> Yes.
>> Is this technically possible?
> Yes.
>> Any security implications?
> DTS is a usual SQL Server Client application. All the security implications are based on this
> fact.
system running SQL Server 2000. Can the DTC be stand alone on a dedicated
server in the external environment and then contact the SQL database through
a specific port? Is this technically possible? Any security implications?Alexis wrote:
> We have a requirement to utilize MS-DTC from internet facing to an internal
> system running SQL Server 2000. Can the DTC be stand alone on a dedicated
> server in the external environment and then contact the SQL database through
> a specific port?
Yes.
> Is this technically possible?
Yes.
> Any security implications?
DTS is a usual SQL Server Client application. All the security
implications are based on this fact.|||Yura, perhaps you misread DTC as DTS. DTC, AFAIK, speaks only RPC which probably makes it tricky
with firewalls (I'm not network expert...). I'm fairly certain that I've read a KB about this,
should be relatively easy to find.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Yura Shalak" <yuras@.nospam.nospam> wrote in message news:up%23UoeohHHA.1456@.TK2MSFTNGP04.phx.gbl...
> Alexis wrote:
>> We have a requirement to utilize MS-DTC from internet facing to an internal system running SQL
>> Server 2000. Can the DTC be stand alone on a dedicated server in the external environment and
>> then contact the SQL database through a specific port?
> Yes.
>> Is this technically possible?
> Yes.
>> Any security implications?
> DTS is a usual SQL Server Client application. All the security implications are based on this
> fact.
Tuesday, February 14, 2012
dt_getobjwithprop_u system procedure
Hi All,
Please tell me what this procedure dt_getobjwithprop_u does.
Thanks in advanced,
TNrun this and problem should be cured. so sayeth the infallable BOL.
alter table dbo.dtproperties add uvalue nvarchar(255) null
go
if exists(select * from dbo.dtproperties) exec('update dbo.dtproperties set uvalue = convert(nvarchar(255), value)')
go
Please tell me what this procedure dt_getobjwithprop_u does.
Thanks in advanced,
TNrun this and problem should be cured. so sayeth the infallable BOL.
alter table dbo.dtproperties add uvalue nvarchar(255) null
go
if exists(select * from dbo.dtproperties) exec('update dbo.dtproperties set uvalue = convert(nvarchar(255), value)')
go
dt_getobjwithprop_u system procedure
Hi All,
Please tell me what this procedure dt_getobjwithprop_u does.
Thanks in advanced,
TN
It's executed with dt_getpropertiesbyid_u when you view
database diagrams which are stored in dtproperties.
-Sue
On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
>Hi All,
>Please tell me what this procedure dt_getobjwithprop_u does.
>Thanks in advanced,
>TN
|||Hi Sue,
thank you for your reponse.
Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
please tell me where I can find document regarding all procedured with pre
fix dt_.
or you tell me about all of them.
Thanks a lot for your help
TN
"Sue Hoegemeier" wrote:
> It's executed with dt_getpropertiesbyid_u when you view
> database diagrams which are stored in dtproperties.
> -Sue
> On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
>
>
|||They aren't officially documented and I don't know of any
other resources that may have documented them in much
detail.
Some are created when you access a database with Visual
Studio and some are used for the data tools used by
Enterprise Manager.
You could always go through and read the source code for
them. You could also run profiler when opening, modifying
and creating diagrams as well as when connecting to the
database using Visual Studio to get the details of what is
used when.
-Sue
On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Sue,
>thank you for your reponse.
>Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
>please tell me where I can find document regarding all procedured with pre
>fix dt_.
>or you tell me about all of them.
>Thanks a lot for your help
>TN
>"Sue Hoegemeier" wrote:
|||Thanks for your help.
TN
"Sue Hoegemeier" wrote:
> They aren't officially documented and I don't know of any
> other resources that may have documented them in much
> detail.
> Some are created when you access a database with Visual
> Studio and some are used for the data tools used by
> Enterprise Manager.
> You could always go through and read the source code for
> them. You could also run profiler when opening, modifying
> and creating diagrams as well as when connecting to the
> database using Visual Studio to get the details of what is
> used when.
> -Sue
> On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
>
>
Please tell me what this procedure dt_getobjwithprop_u does.
Thanks in advanced,
TN
It's executed with dt_getpropertiesbyid_u when you view
database diagrams which are stored in dtproperties.
-Sue
On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
>Hi All,
>Please tell me what this procedure dt_getobjwithprop_u does.
>Thanks in advanced,
>TN
|||Hi Sue,
thank you for your reponse.
Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
please tell me where I can find document regarding all procedured with pre
fix dt_.
or you tell me about all of them.
Thanks a lot for your help
TN
"Sue Hoegemeier" wrote:
> It's executed with dt_getpropertiesbyid_u when you view
> database diagrams which are stored in dtproperties.
> -Sue
> On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
>
>
|||They aren't officially documented and I don't know of any
other resources that may have documented them in much
detail.
Some are created when you access a database with Visual
Studio and some are used for the data tools used by
Enterprise Manager.
You could always go through and read the source code for
them. You could also run profiler when opening, modifying
and creating diagrams as well as when connecting to the
database using Visual Studio to get the details of what is
used when.
-Sue
On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Sue,
>thank you for your reponse.
>Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
>please tell me where I can find document regarding all procedured with pre
>fix dt_.
>or you tell me about all of them.
>Thanks a lot for your help
>TN
>"Sue Hoegemeier" wrote:
|||Thanks for your help.
TN
"Sue Hoegemeier" wrote:
> They aren't officially documented and I don't know of any
> other resources that may have documented them in much
> detail.
> Some are created when you access a database with Visual
> Studio and some are used for the data tools used by
> Enterprise Manager.
> You could always go through and read the source code for
> them. You could also run profiler when opening, modifying
> and creating diagrams as well as when connecting to the
> database using Visual Studio to get the details of what is
> used when.
> -Sue
> On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
>
>
dt_getobjwithprop_u system procedure
Hi All,
Please tell me what this procedure dt_getobjwithprop_u does.
Thanks in advanced,
TNIt's executed with dt_getpropertiesbyid_u when you view
database diagrams which are stored in dtproperties.
-Sue
On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
>Hi All,
>Please tell me what this procedure dt_getobjwithprop_u does.
>Thanks in advanced,
>TN|||Hi Sue,
thank you for your reponse.
Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
please tell me where I can find document regarding all procedured with pre
fix dt_.
or you tell me about all of them.
Thanks a lot for your help
TN
"Sue Hoegemeier" wrote:
> It's executed with dt_getpropertiesbyid_u when you view
> database diagrams which are stored in dtproperties.
> -Sue
> On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
>
>|||They aren't officially documented and I don't know of any
other resources that may have documented them in much
detail.
Some are created when you access a database with Visual
Studio and some are used for the data tools used by
Enterprise Manager.
You could always go through and read the source code for
them. You could also run profiler when opening, modifying
and creating diagrams as well as when connecting to the
database using Visual Studio to get the details of what is
used when.
-Sue
On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Sue,
>thank you for your reponse.
>Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
>please tell me where I can find document regarding all procedured with pre
>fix dt_.
>or you tell me about all of them.
>Thanks a lot for your help
>TN
>"Sue Hoegemeier" wrote:
>|||Thanks for your help.
TN
"Sue Hoegemeier" wrote:
> They aren't officially documented and I don't know of any
> other resources that may have documented them in much
> detail.
> Some are created when you access a database with Visual
> Studio and some are used for the data tools used by
> Enterprise Manager.
> You could always go through and read the source code for
> them. You could also run profiler when opening, modifying
> and creating diagrams as well as when connecting to the
> database using Visual Studio to get the details of what is
> used when.
> -Sue
> On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
>
>
Please tell me what this procedure dt_getobjwithprop_u does.
Thanks in advanced,
TNIt's executed with dt_getpropertiesbyid_u when you view
database diagrams which are stored in dtproperties.
-Sue
On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
>Hi All,
>Please tell me what this procedure dt_getobjwithprop_u does.
>Thanks in advanced,
>TN|||Hi Sue,
thank you for your reponse.
Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
please tell me where I can find document regarding all procedured with pre
fix dt_.
or you tell me about all of them.
Thanks a lot for your help
TN
"Sue Hoegemeier" wrote:
> It's executed with dt_getpropertiesbyid_u when you view
> database diagrams which are stored in dtproperties.
> -Sue
> On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
>
>|||They aren't officially documented and I don't know of any
other resources that may have documented them in much
detail.
Some are created when you access a database with Visual
Studio and some are used for the data tools used by
Enterprise Manager.
You could always go through and read the source code for
them. You could also run profiler when opening, modifying
and creating diagrams as well as when connecting to the
database using Visual Studio to get the details of what is
used when.
-Sue
On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Sue,
>thank you for your reponse.
>Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
>please tell me where I can find document regarding all procedured with pre
>fix dt_.
>or you tell me about all of them.
>Thanks a lot for your help
>TN
>"Sue Hoegemeier" wrote:
>|||Thanks for your help.
TN
"Sue Hoegemeier" wrote:
> They aren't officially documented and I don't know of any
> other resources that may have documented them in much
> detail.
> Some are created when you access a database with Visual
> Studio and some are used for the data tools used by
> Enterprise Manager.
> You could always go through and read the source code for
> them. You could also run profiler when opening, modifying
> and creating diagrams as well as when connecting to the
> database using Visual Studio to get the details of what is
> used when.
> -Sue
> On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
>
>
dt_getobjwithprop_u system procedure
Hi All,
Please tell me what this procedure dt_getobjwithprop_u does.
Thanks in advanced,
TNIt's executed with dt_getpropertiesbyid_u when you view
database diagrams which are stored in dtproperties.
-Sue
On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
>Hi All,
>Please tell me what this procedure dt_getobjwithprop_u does.
>Thanks in advanced,
>TN|||Hi Sue,
thank you for your reponse.
Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
please tell me where I can find document regarding all procedured with pre
fix dt_.
or you tell me about all of them.
Thanks a lot for your help
TN
"Sue Hoegemeier" wrote:
> It's executed with dt_getpropertiesbyid_u when you view
> database diagrams which are stored in dtproperties.
> -Sue
> On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
> >Hi All,
> >
> >Please tell me what this procedure dt_getobjwithprop_u does.
> >
> >Thanks in advanced,
> >TN
>|||They aren't officially documented and I don't know of any
other resources that may have documented them in much
detail.
Some are created when you access a database with Visual
Studio and some are used for the data tools used by
Enterprise Manager.
You could always go through and read the source code for
them. You could also run profiler when opening, modifying
and creating diagrams as well as when connecting to the
database using Visual Studio to get the details of what is
used when.
-Sue
On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
>Hi Sue,
>thank you for your reponse.
>Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
>please tell me where I can find document regarding all procedured with pre
>fix dt_.
>or you tell me about all of them.
>Thanks a lot for your help
>TN
>"Sue Hoegemeier" wrote:
>> It's executed with dt_getpropertiesbyid_u when you view
>> database diagrams which are stored in dtproperties.
>> -Sue
>> On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
>> <TN@.discussions.microsoft.com> wrote:
>> >Hi All,
>> >
>> >Please tell me what this procedure dt_getobjwithprop_u does.
>> >
>> >Thanks in advanced,
>> >TN
>>|||Thanks for your help.
TN
"Sue Hoegemeier" wrote:
> They aren't officially documented and I don't know of any
> other resources that may have documented them in much
> detail.
> Some are created when you access a database with Visual
> Studio and some are used for the data tools used by
> Enterprise Manager.
> You could always go through and read the source code for
> them. You could also run profiler when opening, modifying
> and creating diagrams as well as when connecting to the
> database using Visual Studio to get the details of what is
> used when.
> -Sue
> On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
> >Hi Sue,
> >
> >thank you for your reponse.
> >Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
> >please tell me where I can find document regarding all procedured with pre
> >fix dt_.
> >or you tell me about all of them.
> >
> >Thanks a lot for your help
> >TN
> >
> >"Sue Hoegemeier" wrote:
> >
> >> It's executed with dt_getpropertiesbyid_u when you view
> >> database diagrams which are stored in dtproperties.
> >>
> >> -Sue
> >>
> >> On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
> >> <TN@.discussions.microsoft.com> wrote:
> >>
> >> >Hi All,
> >> >
> >> >Please tell me what this procedure dt_getobjwithprop_u does.
> >> >
> >> >Thanks in advanced,
> >> >TN
> >>
> >>
>
Please tell me what this procedure dt_getobjwithprop_u does.
Thanks in advanced,
TNIt's executed with dt_getpropertiesbyid_u when you view
database diagrams which are stored in dtproperties.
-Sue
On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
>Hi All,
>Please tell me what this procedure dt_getobjwithprop_u does.
>Thanks in advanced,
>TN|||Hi Sue,
thank you for your reponse.
Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
please tell me where I can find document regarding all procedured with pre
fix dt_.
or you tell me about all of them.
Thanks a lot for your help
TN
"Sue Hoegemeier" wrote:
> It's executed with dt_getpropertiesbyid_u when you view
> database diagrams which are stored in dtproperties.
> -Sue
> On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
> >Hi All,
> >
> >Please tell me what this procedure dt_getobjwithprop_u does.
> >
> >Thanks in advanced,
> >TN
>|||They aren't officially documented and I don't know of any
other resources that may have documented them in much
detail.
Some are created when you access a database with Visual
Studio and some are used for the data tools used by
Enterprise Manager.
You could always go through and read the source code for
them. You could also run profiler when opening, modifying
and creating diagrams as well as when connecting to the
database using Visual Studio to get the details of what is
used when.
-Sue
On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
<TN@.discussions.microsoft.com> wrote:
>Hi Sue,
>thank you for your reponse.
>Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
>please tell me where I can find document regarding all procedured with pre
>fix dt_.
>or you tell me about all of them.
>Thanks a lot for your help
>TN
>"Sue Hoegemeier" wrote:
>> It's executed with dt_getpropertiesbyid_u when you view
>> database diagrams which are stored in dtproperties.
>> -Sue
>> On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
>> <TN@.discussions.microsoft.com> wrote:
>> >Hi All,
>> >
>> >Please tell me what this procedure dt_getobjwithprop_u does.
>> >
>> >Thanks in advanced,
>> >TN
>>|||Thanks for your help.
TN
"Sue Hoegemeier" wrote:
> They aren't officially documented and I don't know of any
> other resources that may have documented them in much
> detail.
> Some are created when you access a database with Visual
> Studio and some are used for the data tools used by
> Enterprise Manager.
> You could always go through and read the source code for
> them. You could also run profiler when opening, modifying
> and creating diagrams as well as when connecting to the
> database using Visual Studio to get the details of what is
> used when.
> -Sue
> On Mon, 14 Feb 2005 13:23:01 -0800, "TN"
> <TN@.discussions.microsoft.com> wrote:
> >Hi Sue,
> >
> >thank you for your reponse.
> >Please tell me more about dt_getpropertiesbyid_u. I don't know it as well.
> >please tell me where I can find document regarding all procedured with pre
> >fix dt_.
> >or you tell me about all of them.
> >
> >Thanks a lot for your help
> >TN
> >
> >"Sue Hoegemeier" wrote:
> >
> >> It's executed with dt_getpropertiesbyid_u when you view
> >> database diagrams which are stored in dtproperties.
> >>
> >> -Sue
> >>
> >> On Mon, 14 Feb 2005 11:35:02 -0800, "TN"
> >> <TN@.discussions.microsoft.com> wrote:
> >>
> >> >Hi All,
> >> >
> >> >Please tell me what this procedure dt_getobjwithprop_u does.
> >> >
> >> >Thanks in advanced,
> >> >TN
> >>
> >>
>
Subscribe to:
Posts (Atom)