DTS not able to open

Hi experts,
i have faced one issue with DTS, my office SQL server is 2000 x86
version, but my labtop using SQL Server managment studio, when i try
to expend the office SQL DTS package, which show me "this package
cannot be edited" and the following msg is "SQL server 2005 DTS
Designer components are required to edit DTS packages", "Install the
special Web download, SQL Server 2000 DTS designer components to use
this feature". however my co-worker are able to open, this is
something special , and my SQL studio setting almost same as him.
my labtop detail:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600
pls advise, many thanksHi
Check out the information on
http://technet.microsoft.com/en-us/library/ms143706.aspx for more
information. If you need to edit a DTS package you will need to download the
Microsoft SQL Server 2000 DTS Designer Components from the features pac
http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17
John
"XJ" wrote:
> Hi experts,
> i have faced one issue with DTS, my office SQL server is 2000 x86
> version, but my labtop using SQL Server managment studio, when i try
> to expend the office SQL DTS package, which show me "this package
> cannot be edited" and the following msg is "SQL server 2005 DTS
> Designer components are required to edit DTS packages", "Install the
> special Web download, SQL Server 2000 DTS designer components to use
> this feature". however my co-worker are able to open, this is
> something special , and my SQL studio setting almost same as him.
> my labtop detail:
> Microsoft SQL Server Management Studio 9.00.3042.00
> Microsoft Analysis Services Client Tools 2005.090.3042.00
> Microsoft Data Access Components (MDAC) 2000.085.1117.00
> (xpsp_sp2_rtm.040803-2158)
> Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer 7.0.5730.13
> Microsoft .NET Framework 2.0.50727.832
> Operating System 5.1.2600
>
> pls advise, many thanks
>

DTS not able to open

Hi experts,
i have faced one issue with DTS, my office SQL server is 2000 x86
version, but my labtop using SQL Server managment studio, when i try
to expend the office SQL DTS package, which show me "this package
cannot be edited" and the following msg is "SQL server 2005 DTS
Designer components are required to edit DTS packages", "Install the
special Web download, SQL Server 2000 DTS designer components to use
this feature". however my co-worker are able to open, this is
something special , and my SQL studio setting almost same as him.
my labtop detail:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600
pls advise, many thanksHi
Check out the information on
http://technet.microsoft.com/en-us/...y/ms143706.aspx for more
information. If you need to edit a DTS package you will need to download the
Microsoft SQL Server 2000 DTS Designer Components from the features pack
http://www.microsoft.com/downloads/.../>
a42ec403d17
John
"XJ" wrote:

> Hi experts,
> i have faced one issue with DTS, my office SQL server is 2000 x86
> version, but my labtop using SQL Server managment studio, when i try
> to expend the office SQL DTS package, which show me "this package
> cannot be edited" and the following msg is "SQL server 2005 DTS
> Designer components are required to edit DTS packages", "Install the
> special Web download, SQL Server 2000 DTS designer components to use
> this feature". however my co-worker are able to open, this is
> something special , and my SQL studio setting almost same as him.
> my labtop detail:
> Microsoft SQL Server Management Studio 9.00.3042.00
> Microsoft Analysis Services Client Tools 2005.090.3042.00
> Microsoft Data Access Components (MDAC) 2000.085.1117.00
> (xpsp_sp2_rtm.040803-2158)
> Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer 7.0.5730.13
> Microsoft .NET Framework 2.0.50727.832
> Operating System 5.1.2600
>
> pls advise, many thanks
>

DTS no error, but no data either...

Hey all - Quick question,
I'm trying to use DTS to move SQL server data to Oracle.

I select the table(s) I want to move, use the oracle oledb driver (i test connected/credentials successfully) and wait...process goes through without a hitch, but when I go to oracle and do a select * I've got nothing.

Any insight into this?Did you get any errors?

How much data?

I would bcp the data out and use SQLLOader on the Oracle side...

But that's just me...|||Does DTS automatically commit the inserts?|||Seems like DTS is working the problem was it is putting quotations around the tablse...ie
"tablespacename"."tablename" is there any way to disable the quotations around the tables?? If i create the table with a script in oracle - it does the same thing.|||Answered my own question. Thanks anyway!

DTS Network Traffic

Hi,
I am trying to confirm a hypothesis on the Network traffic that a certain
DTS will generate, my environment is configured as follows:
Server A: SQL Server Instance to act as source
Server B: SQL Server Instance to execute DTS Package
Server C: File Server at remote location to be target server
If I run a DTS package in Server B to extract information from Server A
and generate a fixed length flat file in Server C. Is it valid to say that,
all the information required to build the flat file will travel on my network
from Server A to Server B first and then it will be dumped in the flat file
on Server C?
Is there any way to still use Server B to execute the DTS package but, have
the network traffic go directly from Server A to Server C?
Thanks a lot!
Ignacio
why dont you just have serverA execcute the DTS job straight to C?
"i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
> Hi,
> I am trying to confirm a hypothesis on the Network traffic that a certain
> DTS will generate, my environment is configured as follows:
> Server A: SQL Server Instance to act as source
> Server B: SQL Server Instance to execute DTS Package
> Server C: File Server at remote location to be target server
> If I run a DTS package in Server B to extract information from Server A
> and generate a fixed length flat file in Server C. Is it valid to say
> that,
> all the information required to build the flat file will travel on my
> network
> from Server A to Server B first and then it will be dumped in the flat
> file
> on Server C?
> Is there any way to still use Server B to execute the DTS package but,
> have
> the network traffic go directly from Server A to Server C?
> Thanks a lot!
> Ignacio
|||They are on different newtorks and have different administrators, Server A's
security is much more strict than Server B which I administer.
"Immy" wrote:

> why dont you just have serverA execcute the DTS job straight to C?
> "i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
> news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
>
>

DTS Network Traffic

Hi,
I am trying to confirm a hypothesis on the Network traffic that a certain
DTS will generate, my environment is configured as follows:
Server A: SQL Server Instance to act as source
Server B: SQL Server Instance to execute DTS Package
Server C: File Server at remote location to be target server
If I run a DTS package in Server B to extract information from Server A
and generate a fixed length flat file in Server C. Is it valid to say that,
all the information required to build the flat file will travel on my networ
k
from Server A to Server B first and then it will be dumped in the flat file
on Server C?
Is there any way to still use Server B to execute the DTS package but, have
the network traffic go directly from Server A to Server C?
Thanks a lot!
Ignaciowhy dont you just have serverA execcute the DTS job straight to C?
"i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
> Hi,
> I am trying to confirm a hypothesis on the Network traffic that a certain
> DTS will generate, my environment is configured as follows:
> Server A: SQL Server Instance to act as source
> Server B: SQL Server Instance to execute DTS Package
> Server C: File Server at remote location to be target server
> If I run a DTS package in Server B to extract information from Server A
> and generate a fixed length flat file in Server C. Is it valid to say
> that,
> all the information required to build the flat file will travel on my
> network
> from Server A to Server B first and then it will be dumped in the flat
> file
> on Server C?
> Is there any way to still use Server B to execute the DTS package but,
> have
> the network traffic go directly from Server A to Server C?
> Thanks a lot!
> Ignacio|||They are on different newtorks and have different administrators, Server A's
security is much more strict than Server B which I administer.
"Immy" wrote:

> why dont you just have serverA execcute the DTS job straight to C?
> "i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
> news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
>
>

DTS Missing Field

i've run into a problem with running a dts job that imports an access db
into sql located on same win 2003 server. the database has no relationships
and has
worked fine until i recently added a new field in a table in access.
crazy as it may sound, the dts job moves every field over fine except the
new field. I tested the job by creating a new table altogether and it
transforms
fine.
there is nothing special about the data type, etc. it's just another integer
field like other existing fields.
Where can I look in a log for a detailed description of a job? is it from
inside QA?
I should mention that my dts job is dropping and recreating each table in
sql 2000.Hi Scott,
Thank you for using the newsgroup and it is my pleasure to help you with
your issue.
As my understanding of your information, you have a DTS package run as a
job. Then DTS package will import the data from a access database to an SQL
Server database. It runs fine in the past. Then you add a new column in the
Access database table then when the job runs, you found that the data in
the new add column is not imported to the SQL Server, right? If I
misunderstood, please feel free to let me know.
Based on my experience, after you design the DTS package, when there is
some modification on the table, such as add a column or delete a column,
it will be reflected in the old DTS package. However, the data transform
between the database should be specified. It could not be specified in the
DTS package automatically.
So, in your Enterprise Manager, please open the DTS package in the design
window, and right click the Transform Data Task ( which is the arrow link
the transformation data source( access database) and the data destination
(SQL server database)), choose 'Properties'. In the Source tab and the
Destination tab, you will notice that the new added column is there in both
table and then in the Transformation tab, you will see the transformation
of the columns between the source and the destination. Then, you will
notice that there are no transformation between new-added columns in the
source and destination. Please click the 'New' button and choose the 'Copy
column', then press OK. Then there is a new window titled 'Transformation
Options' prompt, you should specify the source column and the destination
column, which are the new added columns. Then, you could run the DTS
package and check if the DTS package execut and got the expected
transformation. Then you could run this DTS package as your job.
You could check what the transformation is doing by checking the properties
of the destination and the source and the transformation in the DTS package
design window and use the Profiler of SQL Server to catch what was
executed. For your case, I would recommend that you should check that if
the new-added columns' transformation is added in the DTS package.
Hope this helps and if you still have questions, please feel free to post
new message here and we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Scott,
I am reviewing your post and since we have not heard from you for some
time, I wonder if my answer is helpful in solving your problem or if you
still have any questions that we could help. For any question, please feel
free to post message here and we are glad to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

DTS migration wizard, where does it put migrated version?

From SQL Server Management Studio I right click on Management/Legacy/DTS and select Migration Wizard and enter a SQL Server Source and Destination. A list of DTS packages from the source server is displayed and I select one of the DTS packages and give the destination a unique name. The wizard runs and says it's successful. I can't find the new SSIS version of the DTS package with the new name that I've given it, however. Where does it put the new migrated copy of the DTS package.

Thanks,

John

In Sql Management Studio, under the Object Explorer window in the Connect drop down choose Integration Services, and it will show you all stored packages on that instance.|||Thanks, this helps. Now I'd like to find out how to edit the migrated version. How to I get to it from BI Dev Studio?|||

All of the stored packages will usually be in ~\Program Files\Microsoft SQL Server\90\DTS\Packages

DTS migration wizard, how to edit MSDB packages?

Thanks to Sean for helping me find the migrated packages. I'd like to edit one of the connections on a bunch of packages that I migrated. I see in the Run Package there are configuration options that would allow me to mofify the connection string at that point in time, but I would like to modify the package so it has the new connection string. I was thinking I could access it in BI Dev studio, but I'm not sure how to get to it. I suppose I could migrate to a file and then edit the file prior to importing, but I'm curious if there's a way I can modify the packages that show up under Integration Services/Stored Packages/MSDB.

Thanks,

John

You'll have to export it to a file, and then edit it with BIDS. Afterwards import it back in. :)

DTS Migration Wizard question

Hi,
I've upgraded from 2000 to 2005, 2005 on a new server too.
I have moved a DTS package from the 2000 box to 2005 box & have performed th
DTS Migration Wizard.
Now I want to fiddle with the design of the package in Business Intelligence
Design Studio. Where the heck is it (the migrated package)? How do I open
the package in this wierd GUI?
cheersTry to connect to Integration Services and expand "Storage Packages", just t
o
see where you saved your package.
To edit the package, run Business Intelligence Development Studio, create a
new Project (using Integration Services Template) and in the new Solution ad
d
an existing package; following the dialog boxes you should navigate to the
path where your package is stored.
Gilberto Zampatti
"dc" wrote:

> Hi,
> I've upgraded from 2000 to 2005, 2005 on a new server too.
> I have moved a DTS package from the 2000 box to 2005 box & have performed
th
> DTS Migration Wizard.
> Now I want to fiddle with the design of the package in Business Intelligen
ce
> Design Studio. Where the heck is it (the migrated package)? How do I ope
n
> the package in this wierd GUI?
> cheers
>
>

DTS Migration Wizard question

Hi,
I've upgraded from 2000 to 2005, 2005 on a new server too.
I have moved a DTS package from the 2000 box to 2005 box & have performed th
DTS Migration Wizard.
Now I want to fiddle with the design of the package in Business Intelligence
Design Studio. Where the heck is it (the migrated package)? How do I open
the package in this wierd GUI?
cheersTry to connect to Integration Services and expand "Storage Packages", just to
see where you saved your package.
To edit the package, run Business Intelligence Development Studio, create a
new Project (using Integration Services Template) and in the new Solution add
an existing package; following the dialog boxes you should navigate to the
path where your package is stored.
Gilberto Zampatti
"dc" wrote:
> Hi,
> I've upgraded from 2000 to 2005, 2005 on a new server too.
> I have moved a DTS package from the 2000 box to 2005 box & have performed th
> DTS Migration Wizard.
> Now I want to fiddle with the design of the package in Business Intelligence
> Design Studio. Where the heck is it (the migrated package)? How do I open
> the package in this wierd GUI?
> cheers
>
>

DTS Migration Wizard error

I'm using SQL Server 2005 Enterprise x64 and when attempting to migrate a DTS from our SQL Server 2000 Standard x86 server I received the following error message:

DTS Migration Wizard Error

Could not load file or assembly 'Microsoft.SqlServer.Exec80PackageTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of it's dependencies. The system cannot find the file specified.

Click Abort to stop the migration of the current package.

Click Retry to retry the operation.

Click Skip to skip the migration of the current task and continue to the next task.

From the error message, it would appear something did not install or register correctly. Any idea on what is missing and how I can fix it?

Hi there,

Did you do a full SSIS install, or did you install the Migration Wizard by itself? I believe you also need choose "Legacy Components" from the setup if you choose to install the Migration Wizard without the rest of the workbench. That might be the cause of the error you're seeing.

Thanks,

~Matt

|||

I chose to install all (full) components, both server and tools, during my installation of SQL Server 2005 Evaluation Edition. I found it strange that the icon said MS Visual Studio Premier Edition -enu instead of SQL Server Business Intelligence Development Studio. I tried a repair on the MS Visual Studio Premier Edition from Add / Remove Programs but it didn't help. I then removed it using Add / Remove Programs. However, when I fire up the SQL Server 2005 Evaluation Edition setup and attempted to reinstall the tools, it said they were already installed and would not let me go any further. Is a reboot of the production server necessary for Windows 2003 Enterprise to realize I uninstalled MS Visual Studio?

Thanks for your response Matt!

|||

The Visual Studio icon will only be labeled "SQL Server Business Intelligence Development Studio" under the SQL Server folder in the start menu. Your old visual studio icons won't change (they all point to the same thing).

You shouldn't have to reboot after installing SQL Server, but if you've done a repair, I'm not sure what state that puts you in. You might want to uninstall it all and start over again.

The Migration Wizard will be looking for the Microsoft.SqlServer.Exec80PackageTask assembly in the GAC - you might want to make sure it's there. This task gets installed when you select "Legacy Components" or the workbench, so doing a full install should give you all the bits you need.

|||That is the strange part. MS Visual Studio 2005 was not previously installed on this machine; it came across when I chose to install every component of the SQL Server 2005 Eval Edition installation. And the icon in the SQL Server folder didn't say BIDS, instead it was labeled MS Visual Studio 2005. Either way, I have now uninstalled MS Visual Studio 2005 and it looks like I will need to reboot my server before it recognizes the change as it will not allow me to re-install them at this point.|||I ended up uninstalling and reinstalling all of SQL Server 2005 and components. Then to address the missing Business Intellligence projects; I finallly found the answer, In MS Visual Studio (BIDS) click on Tools - Import and Export Settings - Import Selected Environment Settings - Yes, Save my current settings and then highlight "Business Intelligence Settings" and click on finish. This will add the Business Intelligence projects to BIDS.

DTS Migration Wizard error

I'm using SQL Server 2005 Enterprise x64 and when attempting to migrate a DTS from our SQL Server 2000 Standard x86 server I received the following error message:

DTS Migration Wizard Error

Could not load file or assembly 'Microsoft.SqlServer.Exec80PackageTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of it's dependencies. The system cannot find the file specified.

Click Abort to stop the migration of the current package.

Click Retry to retry the operation.

Click Skip to skip the migration of the current task and continue to the next task.

From the error message, it would appear something did not install or register correctly. Any idea on what is missing and how I can fix it?

Hi there,

Did you do a full SSIS install, or did you install the Migration Wizard by itself? I believe you also need choose "Legacy Components" from the setup if you choose to install the Migration Wizard without the rest of the workbench. That might be the cause of the error you're seeing.

Thanks,

~Matt

|||

I chose to install all (full) components, both server and tools, during my installation of SQL Server 2005 Evaluation Edition. I found it strange that the icon said MS Visual Studio Premier Edition -enu instead of SQL Server Business Intelligence Development Studio. I tried a repair on the MS Visual Studio Premier Edition from Add / Remove Programs but it didn't help. I then removed it using Add / Remove Programs. However, when I fire up the SQL Server 2005 Evaluation Edition setup and attempted to reinstall the tools, it said they were already installed and would not let me go any further. Is a reboot of the production server necessary for Windows 2003 Enterprise to realize I uninstalled MS Visual Studio?

Thanks for your response Matt!

|||

The Visual Studio icon will only be labeled "SQL Server Business Intelligence Development Studio" under the SQL Server folder in the start menu. Your old visual studio icons won't change (they all point to the same thing).

You shouldn't have to reboot after installing SQL Server, but if you've done a repair, I'm not sure what state that puts you in. You might want to uninstall it all and start over again.

The Migration Wizard will be looking for the Microsoft.SqlServer.Exec80PackageTask assembly in the GAC - you might want to make sure it's there. This task gets installed when you select "Legacy Components" or the workbench, so doing a full install should give you all the bits you need.

|||That is the strange part. MS Visual Studio 2005 was not previously installed on this machine; it came across when I chose to install every component of the SQL Server 2005 Eval Edition installation. And the icon in the SQL Server folder didn't say BIDS, instead it was labeled MS Visual Studio 2005. Either way, I have now uninstalled MS Visual Studio 2005 and it looks like I will need to reboot my server before it recognizes the change as it will not allow me to re-install them at this point.|||I ended up uninstalling and reinstalling all of SQL Server 2005 and components. Then to address the missing Business Intellligence projects; I finallly found the answer, In MS Visual Studio (BIDS) click on Tools - Import and Export Settings - Import Selected Environment Settings - Yes, Save my current settings and then highlight "Business Intelligence Settings" and click on finish. This will add the Business Intelligence projects to BIDS.

DTS Migration wizard - solved

i am trying to use the DTS migration wizard in sql server 2005 to migrate some of the DTS packages that i have on sql server 2000.

After entering the source and destination server i get the following error:

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)

Does anyone know the reson behind this?

Thanks for any help.

I've just installed Server 2005 and am getting the same message. The earlier threads refer to special characters and leading or trailing spaces. I've tried the wizard on a few packages that have nothing but letters in the name, and I get the above message. I tried repairing .NET 2.0 as well (didn't work).

What else should I/we try?

Thanks,

K

|||

Found a forum where a user clarified that NONE of the DTS packages can have a leading/trailing space. Well, one out of a hundred or so packages had a space; after I fixed that one, the wizard worked.

Find the spaces (thanks to Joseph Sack's SQL Server blog):

SELECT DISTINCT name
FROM msdb.dbo.sysdtspackages
WHERE name LIKE '% '

and I'd suggest: or name LIKE ' %'

|||

Thanks a lot.

I had one package that had a space. After i deleted the space i was able to get a little further. but when i hit finish, All the packages display "Stopped" and none gets transferred.

Thanks

DTS Migration wizard - same here

i am trying to use the DTS migration wizard in sql server 2005 to migrate some of the DTS packages that i have on sql server 2000.

After entering the source and destination server i get the following error:

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)

Does anyone know the reson behind this?

Thanks for any help.

I've just installed Server 2005 and am getting the same message. The earlier threads refer to special characters and leading or trailing spaces. I've tried the wizard on a few packages that have nothing but letters in the name, and I get the above message. I tried repairing .NET 2.0 as well (didn't work).

What else should I/we try?

Thanks,

K

|||

Found a forum where a user clarified that NONE of the DTS packages can have a leading/trailing space. Well, one out of a hundred or so packages had a space; after I fixed that one, the wizard worked.

Find the spaces (thanks to Joseph Sack's SQL Server blog):

SELECT DISTINCT name
FROM msdb.dbo.sysdtspackages
WHERE name LIKE '% '

and I'd suggest: or name LIKE ' %'

|||

Thanks a lot.

I had one package that had a space. After i deleted the space i was able to get a little further. but when i hit finish, All the packages display "Stopped" and none gets transferred.

Thanks

DTS Migration to SSIS

Good Day,

I am currently in the process of migrating my DTS packages to SSISone at a timeand have come accross the following error during the excecution of a "Copy SQL Server Objects Task". The exact error is:

[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Version80 database compatibility level is not supported.".

What I am doing with this particular task is to copy a table(s) from another SQL Server, to the current SQL Server. The original location is a SQL2000 DB table. In the near future the source server for this table will be a SQL 2005 server but not until the current migration has been completed.

I have looked at all of the properties, but can not find anything relating to the db compatibilty level. Is there an easier way? Or a setting that I can change to accomplish what I am trying?

Thanks for any help/suggestions.

I have the same error . I'm copying from SQL 2005 to SQL 2005, and selecting all tables. Also having it copy all indexes, triggers, etc. Sometimes I can actually get it to execute successfully, however; there are no tables that have been copied when this happens. I'm betting this is another bug.

Really need this problem resolved since there already is a bug that have been recently report using the Transfer Database Object. Especially if we need to move a SQL 2005 database back to 2000, which my the situation in a case for me the other day. The only way was to export all the tables and then go back into the 2000 db and re-create the indexes, and relationships - not good.

We need the SSIS tools working correctly - DBA's rely on them!.

Hoping for quick resolutions.

Update: There is a solution. Check the Properties\Options of the database and look at the compatibility level. Most likely it is set to 8.0 as was mine. Change to 9.0 and it should now run. - Unfortunately when I ran mine, it led me to believe that everthing ran fine, but when I looked at the database, no user tables, etc. were there.

|||Try changing the provider to Microsoft OLE DB Provider for SQL server. The default provider probably does not work for SQL server 2000.

DTS Migration to SSIS

Good Day,

I am currently in the process of migrating my DTS packages to SSISone at a timeand have come accross the following error during the excecution of a "Copy SQL Server Objects Task". The exact error is:

[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Version80 database compatibility level is not supported.".

What I am doing with this particular task is to copy a table(s) from another SQL Server, to the current SQL Server. The original location is a SQL2000 DB table. In the near future the source server for this table will be a SQL 2005 server but not until the current migration has been completed.

I have looked at all of the properties, but can not find anything relating to the db compatibilty level. Is there an easier way? Or a setting that I can change to accomplish what I am trying?

Thanks for any help/suggestions.

I have the same error . I'm copying from SQL 2005 to SQL 2005, and selecting all tables. Also having it copy all indexes, triggers, etc. Sometimes I can actually get it to execute successfully, however; there are no tables that have been copied when this happens. I'm betting this is another bug.

Really need this problem resolved since there already is a bug that have been recently report using the Transfer Database Object. Especially if we need to move a SQL 2005 database back to 2000, which my the situation in a case for me the other day. The only way was to export all the tables and then go back into the 2000 db and re-create the indexes, and relationships - not good.

We need the SSIS tools working correctly - DBA's rely on them!.

Hoping for quick resolutions.

Update: There is a solution. Check the Properties\Options of the database and look at the compatibility level. Most likely it is set to 8.0 as was mine. Change to 9.0 and it should now run. - Unfortunately when I ran mine, it led me to believe that everthing ran fine, but when I looked at the database, no user tables, etc. were there.

|||Try changing the provider to Microsoft OLE DB Provider for SQL server. The default provider probably does not work for SQL server 2000.

DTS Migration to SSIS

Good Day,

I am currently in the process of migrating my DTS packages to SSISone at a timeand have come accross the following error during the excecution of a "Copy SQL Server Objects Task". The exact error is:

[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Version80 database compatibility level is not supported.".

What I am doing with this particular task is to copy a table(s) from another SQL Server, to the current SQL Server. The original location is a SQL2000 DB table. In the near future the source server for this table will be a SQL 2005 server but not until the current migration has been completed.

I have looked at all of the properties, but can not find anything relating to the db compatibilty level. Is there an easier way? Or a setting that I can change to accomplish what I am trying?

Thanks for any help/suggestions.

I have the same error . I'm copying from SQL 2005 to SQL 2005, and selecting all tables. Also having it copy all indexes, triggers, etc. Sometimes I can actually get it to execute successfully, however; there are no tables that have been copied when this happens. I'm betting this is another bug.

Really need this problem resolved since there already is a bug that have been recently report using the Transfer Database Object. Especially if we need to move a SQL 2005 database back to 2000, which my the situation in a case for me the other day. The only way was to export all the tables and then go back into the 2000 db and re-create the indexes, and relationships - not good.

We need the SSIS tools working correctly - DBA's rely on them!.

Hoping for quick resolutions.

Update: There is a solution. Check the Properties\Options of the database and look at the compatibility level. Most likely it is set to 8.0 as was mine. Change to 9.0 and it should now run. - Unfortunately when I ran mine, it led me to believe that everthing ran fine, but when I looked at the database, no user tables, etc. were there.

|||Try changing the provider to Microsoft OLE DB Provider for SQL server. The default provider probably does not work for SQL server 2000.

DTS migration to Oracle

Hi!
Do you know any tool ou method to help the migration of an entire DW
repository in SQL Server 2000 to Oracle? And I mean the Dtata Transformation
Services too... I think it is veru difficult to migrate DTS to DML in
Oracle, but who knows there is some tool that transforms DTSs into PL/SQL (I
doubt it, but...).
thanks.
FPG
Hi Filipe,
you are out of luck as far as I am aware....there are few tools to
convert etl from one thing to another....I always recommend to my
clients to use ETL tools that can move from one database to another
with zero changes...and I liked the idea so much I wrote one for
myself...LOL!
At least if you can move your entire ETL/BI subsystem from one OS/RDBMS
platform to another you can push the vendor for a better deal on
maintenance...if you are lucky...
Best Regards
Peter Nolan
www.peternolan.com

DTS migration to Oracle

Hi!
Do you know any tool ou method to help the migration of an entire DW
repository in SQL Server 2000 to Oracle? And I mean the Dtata Transformation
Services too... I think it is veru difficult to migrate DTS to DML in
Oracle, but who knows there is some tool that transforms DTSs into PL/SQL (I
doubt it, but...).
thanks.
FPGHi Filipe,
you are out of luck as far as I am aware....there are few tools to
convert etl from one thing to another....I always recommend to my
clients to use ETL tools that can move from one database to another
with zero changes...and I liked the idea so much I wrote one for
myself...LOL!
At least if you can move your entire ETL/BI subsystem from one OS/RDBMS
platform to another you can push the vendor for a better deal on
maintenance...if you are lucky...
Best Regards
Peter Nolan
www.peternolan.com

DTS migration from ss2000 --> ss2005

Pablo
Right Click on Data Transformation Services and choose Migration Wizard
"Pablo Cognito" <pcognito@.gmail.com> wrote in message
news:uXs7OOJDHHA.3660@.TK2MSFTNGP02.phx.gbl...
> hi,
> I'm planning to move my existing DTS that I've made in ss2000 to ss2005.
> At this moment I'm not planning to migrate existing DTS to SSIS, I just
> want to use backward compatibility for now.
> What's the "best practice" technique for moving ss2000 DTS --> ss2005?
> Thanks
Sorry, firstly save the DTS as stucture storage file
secondly Right Click on Data Transformation Services and choose Import
Package File option
choose Import option
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OMMOegJDHHA.3492@.TK2MSFTNGP06.phx.gbl...
> Pablo
> Right Click on Data Transformation Services and choose Migration Wizard
>
> "Pablo Cognito" <pcognito@.gmail.com> wrote in message
> news:uXs7OOJDHHA.3660@.TK2MSFTNGP02.phx.gbl...
>

DTS migration from ss2000 --> ss2005

hi,
I'm planning to move my existing DTS that I've made in ss2000 to ss2005.
At this moment I'm not planning to migrate existing DTS to SSIS, I
just want to use backward compatibility for now.
What's the "best practice" technique for moving ss2000 DTS --> ss2005?
ThanksPablo
Right Click on Data Transformation Services and choose Migration Wizard
"Pablo Cognito" <pcognito@.gmail.com> wrote in message
news:uXs7OOJDHHA.3660@.TK2MSFTNGP02.phx.gbl...
> hi,
> I'm planning to move my existing DTS that I've made in ss2000 to ss2005.
> At this moment I'm not planning to migrate existing DTS to SSIS, I just
> want to use backward compatibility for now.
> What's the "best practice" technique for moving ss2000 DTS --> ss2005?
> Thanks|||Sorry, firstly save the DTS as stucture storage file
secondly Right Click on Data Transformation Services and choose Import
Package File option
choose Import option
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OMMOegJDHHA.3492@.TK2MSFTNGP06.phx.gbl...
> Pablo
> Right Click on Data Transformation Services and choose Migration Wizard
>
> "Pablo Cognito" <pcognito@.gmail.com> wrote in message
> news:uXs7OOJDHHA.3660@.TK2MSFTNGP02.phx.gbl...
>> hi,
>> I'm planning to move my existing DTS that I've made in ss2000 to ss2005.
>> At this moment I'm not planning to migrate existing DTS to SSIS, I just
>> want to use backward compatibility for now.
>> What's the "best practice" technique for moving ss2000 DTS --> ss2005?
>> Thanks
>

DTS migration from ss2000 --> ss2005

hi,
I'm planning to move my existing DTS that I've made in ss2000 to ss2005.
At this moment I'm not planning to migrate existing DTS to SSIS, I
just want to use backward compatibility for now.
What's the "best practice" technique for moving ss2000 DTS --> ss2005?
ThanksPablo
Right Click on Data Transformation Services and choose Migration Wizard
"Pablo Cognito" <pcognito@.gmail.com> wrote in message
news:uXs7OOJDHHA.3660@.TK2MSFTNGP02.phx.gbl...
> hi,
> I'm planning to move my existing DTS that I've made in ss2000 to ss2005.
> At this moment I'm not planning to migrate existing DTS to SSIS, I just
> want to use backward compatibility for now.
> What's the "best practice" technique for moving ss2000 DTS --> ss2005?
> Thanks|||Sorry, firstly save the DTS as stucture storage file
secondly Right Click on Data Transformation Services and choose Import
Package File option
choose Import option
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OMMOegJDHHA.3492@.TK2MSFTNGP06.phx.gbl...
> Pablo
> Right Click on Data Transformation Services and choose Migration Wizard
>
> "Pablo Cognito" <pcognito@.gmail.com> wrote in message
> news:uXs7OOJDHHA.3660@.TK2MSFTNGP02.phx.gbl...
>

DTS Migration from SQL Server 2000

I’m currently evaluating SQL Server 2005 to what advantages there would be to upgrading from SQL Server 2000. Our existing systems make much use of DTS so it critical for us to be able to run SQL Server 2000 DTS packages in SQL Server 2005.

Having installed the Enterprise SQL Server 2005 CTP successfully on a new Windows 2003 server and following the advice to install Legacy Components I find the Migration Wizard (under Legacy> Data Transformation Services) fails with the following error after entering source and target dialogs:

This wizard will close because it encountered the following error:

Additional Information:

Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index (mscorlib)

Also when trying to open a structured storage DTS file I incur another error:

Unable to load DTS 2000 Runtime. This component may have not been installed

(Microsoft.SqlServer.DtsObjectExplorerUI)

This error seems to imply that the DTS 2000 Runtime needs installing. Can this component be downloaded and installed separately?

John,
The first error sounds like it *could* be a bug. Are you able to open a bug at betaplace?

Regarding your second error....you cannot open a DTS2000 package for editing using SQL Server 2005 tools so don't even bother trying. You need a SQL2000 instance in order to edit your DTS2000 packages.

Happily SQL2000 and SQL2005 can run alongside each other with one (or both) of them as a named instance.

-Jamie|||

Thanks Jamie,

I am not a member of betaplace. Could someone set me up with guest id to log the 1st problem as a possible bug? I’ll install an instance of SQL2000 to overcome the 2nd problem.

|||

Several forum users have reported the following error message when attempting to migrate a DTS package:

TITLE: Microsoft SQL Server
This wizard will close because it encountered the following error:
...
ADDITIONAL INFORMATION:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)
...

One cause of this error, which can easily be reproduced, is a space before or (more likely) after the name of the package.

Unfortunately this problem is not currently detected by Upgrade Advisor when it scans package names for invalid characters.

-Doug

|||

I have the same problem after uppgrading from Sql 2000 Personal to Sql 2005 Standard. The server has been uppgrade from win2000 standard server SP4 to win 2003 standard server SP1

In Mannagement > Legacy folder i'v have altso problems deleting old Mainenance plans. When I delete it it seems do disapair, but when i'm refresh it it comes back.

I have no space in the name of the DTS package

- Rolf

DTS Migration from SQL Server 2000

I’m currently evaluating SQL Server 2005 to what advantages there would be to upgrading from SQL Server 2000. Our existing systems make much use of DTS so it critical for us to be able to run SQL Server 2000 DTS packages in SQL Server 2005.

Having installed the Enterprise SQL Server 2005 CTP successfully on a new Windows 2003 server and following the advice to install Legacy Components I find the Migration Wizard (under Legacy> Data Transformation Services) fails with the following error after entering source and target dialogs:

This wizard will close because it encountered the following error:

Additional Information:

Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index (mscorlib)

Also when trying to open a structured storage DTS file I incur another error:

Unable to load DTS 2000 Runtime. This component may have not been installed

(Microsoft.SqlServer.DtsObjectExplorerUI)

This error seems to imply that the DTS 2000 Runtime needs installing. Can this component be downloaded and installed separately?

John,
The first error sounds like it *could* be a bug. Are you able to open a bug at betaplace?

Regarding your second error....you cannot open a DTS2000 package for editing using SQL Server 2005 tools so don't even bother trying. You need a SQL2000 instance in order to edit your DTS2000 packages.

Happily SQL2000 and SQL2005 can run alongside each other with one (or both) of them as a named instance.

-Jamie|||

Thanks Jamie,

I am not a member of betaplace. Could someone set me up with guest id to log the 1st problem as a possible bug? I’ll install an instance of SQL2000 to overcome the 2nd problem.

|||

Several forum users have reported the following error message when attempting to migrate a DTS package:

TITLE: Microsoft SQL Server
This wizard will close because it encountered the following error:
...
ADDITIONAL INFORMATION:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)
...

One cause of this error, which can easily be reproduced, is a space before or (more likely) after the name of the package.

Unfortunately this problem is not currently detected by Upgrade Advisor when it scans package names for invalid characters.

-Doug

|||

I have the same problem after uppgrading from Sql 2000 Personal to Sql 2005 Standard. The server has been uppgrade from win2000 standard server SP4 to win 2003 standard server SP1

In Mannagement > Legacy folder i'v have altso problems deleting old Mainenance plans. When I delete it it seems do disapair, but when i'm refresh it it comes back.

I have no space in the name of the DTS package

- Rolf

DTS Migration from SQL Server 2000

I’m currently evaluating SQL Server 2005 to what advantages there would be to upgrading from SQL Server 2000. Our existing systems make much use of DTS so it critical for us to be able to run SQL Server 2000 DTS packages in SQL Server 2005.

Having installed the Enterprise SQL Server 2005 CTP successfully on a new Windows 2003 server and following the advice to install Legacy Components I find the Migration Wizard (under Legacy> Data Transformation Services) fails with the following error after entering source and target dialogs:

This wizard will close because it encountered the following error:

Additional Information:

Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index (mscorlib)

Also when trying to open a structured storage DTS file I incur another error:

Unable to load DTS 2000 Runtime. This component may have not been installed

(Microsoft.SqlServer.DtsObjectExplorerUI)

This error seems to imply that the DTS 2000 Runtime needs installing. Can this component be downloaded and installed separately?

John,
The first error sounds like it *could* be a bug. Are you able to open a bug at betaplace?

Regarding your second error....you cannot open a DTS2000 package for editing using SQL Server 2005 tools so don't even bother trying. You need a SQL2000 instance in order to edit your DTS2000 packages.

Happily SQL2000 and SQL2005 can run alongside each other with one (or both) of them as a named instance.

-Jamie|||

Thanks Jamie,

I am not a member of betaplace. Could someone set me up with guest id to log the 1st problem as a possible bug? I’ll install an instance of SQL2000 to overcome the 2nd problem.

|||

Several forum users have reported the following error message when attempting to migrate a DTS package:

TITLE: Microsoft SQL Server
This wizard will close because it encountered the following error:
...
ADDITIONAL INFORMATION:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)
...

One cause of this error, which can easily be reproduced, is a space before or (more likely) after the name of the package.

Unfortunately this problem is not currently detected by Upgrade Advisor when it scans package names for invalid characters.

-Doug

|||

I have the same problem after uppgrading from Sql 2000 Personal to Sql 2005 Standard. The server has been uppgrade from win2000 standard server SP4 to win 2003 standard server SP1

In Mannagement > Legacy folder i'v have altso problems deleting old Mainenance plans. When I delete it it seems do disapair, but when i'm refresh it it comes back.

I have no space in the name of the DTS package

- Rolf

DTS Migration error message

I get the following error message when attempting to migrate DTS packages from SQL Server 2000 to SQL Server 2005:

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)

Could this be it:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=357132&SiteID=1

-Jamie

DTS migration 2000 to 2005

There are two options to move from 2000 sql server to 2005 sql server
database engine.
1. Double click on the DTS package to open in the designer.
Click file--> save as and change the destination server to SQL server
2005. Then save.
Finally the package will be right clicked in 2005 database
engine and migrated to integration services.
2. Save the DTS package as a structured storage file and import
it in sql server 2005 database engine under management --> legacy -->
Data transformation services.
Finally the package will be right clicked in 2005 database
engine and migrated to integration services.
What is the recommended method out of these two? Please illustrate.
My recommendation would be the second. I would also be careful in testing
what the Migration Wizard does when moving it to an SSIS package. If your DTS
package contains a lot of script components, "odd" things can happen. Since
you can still run and maintain your DTS packages under the Migration section
(just not create new ones), depending on the volume of use of DTS, I often
recommend to not migrate and slowly create new ones in SSIS. SSIS is a
daunting tool compared to the DTS designer, so even maintaining once
converted could be time consuming.
My 2 cents - hope that helps.
"sudesh.withanage@.gmail.com" wrote:

> There are two options to move from 2000 sql server to 2005 sql server
> database engine.
> 1. Double click on the DTS package to open in the designer.
> Click file--> save as and change the destination server to SQL server
> 2005. Then save.
> Finally the package will be right clicked in 2005 database
> engine and migrated to integration services.
>
> 2. Save the DTS package as a structured storage file and import
> it in sql server 2005 database engine under management --> legacy -->
> Data transformation services.
> Finally the package will be right clicked in 2005 database
> engine and migrated to integration services.
>
> What is the recommended method out of these two? Please illustrate.
>

DTS migration 2000 to 2005

There are two options to move from 2000 sql server to 2005 sql server
database engine.
1. Double click on the DTS package to open in the designer.
Click file--> save as and change the destination server to SQL server
2005. Then save.
Finally the package will be right clicked in 2005 database
engine and migrated to integration services.
2. Save the DTS package as a structured storage file and import
it in sql server 2005 database engine under management --> legacy -->
Data transformation services.
Finally the package will be right clicked in 2005 database
engine and migrated to integration services.
What is the recommended method out of these two? Please illustrate.My recommendation would be the second. I would also be careful in testing
what the Migration Wizard does when moving it to an SSIS package. If your DTS
package contains a lot of script components, "odd" things can happen. Since
you can still run and maintain your DTS packages under the Migration section
(just not create new ones), depending on the volume of use of DTS, I often
recommend to not migrate and slowly create new ones in SSIS. SSIS is a
daunting tool compared to the DTS designer, so even maintaining once
converted could be time consuming.
My 2 cents - hope that helps.
"sudesh.withanage@.gmail.com" wrote:
> There are two options to move from 2000 sql server to 2005 sql server
> database engine.
> 1. Double click on the DTS package to open in the designer.
> Click file--> save as and change the destination server to SQL server
> 2005. Then save.
> Finally the package will be right clicked in 2005 database
> engine and migrated to integration services.
>
> 2. Save the DTS package as a structured storage file and import
> it in sql server 2005 database engine under management --> legacy -->
> Data transformation services.
> Finally the package will be right clicked in 2005 database
> engine and migrated to integration services.
>
> What is the recommended method out of these two? Please illustrate.
>|||I agree with James as in my experience the conversion in most cases seems to
be unsuccessful. If you have UDL connections or you use a lot of scripting,
especially scripting of the DTS object model, then all that you can convert
to is a placeholder to execute the DTS 2000 package, so you'll be in pretty
much the same situation either way.
I'd recommend refactoring the DTS packages one by one. We're doing this to
take advantage of the new functionality. There's not much on migration
strategies in BOL, but my 2Ps worth is to spend time creating a generic
template that can be used for all your DTS packages. This can include
centralised event handling and centralised configurations. If you get this
right, the package will work in Dev, Test and Live without any
reconfiguration at all, and you'll be able to monitor all packages
centrally.
Cheers,
Paul Ibison

DTS migration 2000 to 2005

There are two options to move from 2000 sql server to 2005 sql server
database engine.
1. Double click on the DTS package to open in the designer.
Click file--> save as and change the destination server to SQL server
2005. Then save.
Finally the package will be right clicked in 2005 database
engine and migrated to integration services.
2. Save the DTS package as a structured storage file and import
it in sql server 2005 database engine under management --> legacy -->
Data transformation services.
Finally the package will be right clicked in 2005 database
engine and migrated to integration services.
What is the recommended method out of these two? Please illustrate.My recommendation would be the second. I would also be careful in testing
what the Migration Wizard does when moving it to an SSIS package. If your DT
S
package contains a lot of script components, "odd" things can happen. Since
you can still run and maintain your DTS packages under the Migration section
(just not create new ones), depending on the volume of use of DTS, I often
recommend to not migrate and slowly create new ones in SSIS. SSIS is a
daunting tool compared to the DTS designer, so even maintaining once
converted could be time consuming.
My 2 cents - hope that helps.
"sudesh.withanage@.gmail.com" wrote:

> There are two options to move from 2000 sql server to 2005 sql server
> database engine.
> 1. Double click on the DTS package to open in the designer.
> Click file--> save as and change the destination server to SQL server
> 2005. Then save.
> Finally the package will be right clicked in 2005 database
> engine and migrated to integration services.
>
> 2. Save the DTS package as a structured storage file and import
> it in sql server 2005 database engine under management --> legacy -->
> Data transformation services.
> Finally the package will be right clicked in 2005 database
> engine and migrated to integration services.
>
> What is the recommended method out of these two? Please illustrate.
>|||I agree with James as in my experience the conversion in most cases seems to
be unsuccessful. If you have UDL connections or you use a lot of scripting,
especially scripting of the DTS object model, then all that you can convert
to is a placeholder to execute the DTS 2000 package, so you'll be in pretty
much the same situation either way.
I'd recommend refactoring the DTS packages one by one. We're doing this to
take advantage of the new functionality. There's not much on migration
strategies in BOL, but my 2Ps worth is to spend time creating a generic
template that can be used for all your DTS packages. This can include
centralised event handling and centralised configurations. If you get this
right, the package will work in Dev, Test and Live without any
reconfiguration at all, and you'll be able to monitor all packages
centrally.
Cheers,
Paul Ibison

DTS Migration

I try to migrate DTS package to SSIS.

Within one DTS package AAA, it calls another DTS package BBB with inner variable.

I successfully migrate the BBB DTS package.

For my AAA package, I replace the DTS_Execute_Task_2000 with Execute Package task. But how do we pass the inner variable parameter ?

There is a Execute DTS2000 Package Task that allows you to do this.

-Jamie

|||Is there a way not to use DTS2000 Package ?|||

You could call dtsrun.exe from the Execute Process Task. Not sure why you'd want to tho.

-Jamie

DTS migration

Hi,

In DTS 2000 package dynamic property task an ini file is read and values for some keys are read. These values are nothing but name of servers on which to run some sql tasks. This dts package has three defined connections. So when the keys are read it will be either one of these three.

For eg. there are three sql tasks. sql1, sql 2 and sql3. sql1 needs to be run against server s1, sql2 against s3 and sql3 aginst s2. So the ini file sets three different variables connection1 to s1,connection2 to s3 and connection3 to s2. These variables are then used to run sql tasks accordingly.

When I migrated this dts package to .dtsx format and edited using SSIS, it gave me a blank format of vb script which we need to code. please help me out in this issue ?

Thanks,

Nit

You need to use Configurations. BOL has plenty of dcoumentation on them, as has Google: http://www.google.co.uk/search?hl=en&q=ssis+configurations&meta=

-Jamie

dts migration

Hi,

How to migrate scheduled jobs from 2000 to 2005. Is this possible by doing bcp out and bcp in system tables which stores sql agent jobs from msdb database ?

Regards

Nit

This question is not related to SSIS. I'd try another forum if I were you. https://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

-Jamie

DTS mapping global variable to column

Hi
I have doubt in DTS -i want 2 export text file into Database - which i can able to do it while running DTS it will prompt inputbox to enter the datetime of transferring which i should update in the datetime column of the table,which i will store this user input value in globalvariables- so how should i map to column.
i placed text object (source) and connection object and active x script object

thanks in advance
HrMay search SQL DTS (http://www.sqldts.com) website.

DTS MAPI profile

I get "Unable to load MAPI profiles" error message in DTS Designer trying to
add "Send Mail" task.
SQLMail has been installed and configured (and tested, it works) on the same
server.
Please help, thank you in advanceWhen in the designer, it's using the current users windows
account and the current users mail profile from the location
or PC where you start up DTS.
Are you opening up the designer while logged onto the server
using the service account or are you doing this from your
PC? If it's from a PC, it doesn't matter what you have setup
on the server.
-Sue
On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:

>I get "Unable to load MAPI profiles" error message in DTS Designer trying t
o
>add "Send Mail" task.
>SQLMail has been installed and configured (and tested, it works) on the sam
e
>server.
>Please help, thank you in advance|||I'm logging on using service account (MSSQLServer and SQLServerAgent run
under this account)
"Sue Hoegemeier" wrote:

> When in the designer, it's using the current users windows
> account and the current users mail profile from the location
> or PC where you start up DTS.
> Are you opening up the designer while logged onto the server
> using the service account or are you doing this from your
> PC? If it's from a PC, it doesn't matter what you have setup
> on the server.
> -Sue
> On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
> <LeonShargorodsky@.discussions.microsoft.com> wrote:
>
>|||If you are logging onto the server directly and logging on
using the service account used by SQL Server and SQL Agent.
And if from here you can see the mail profiles, they have
all been setup, tested and they are working correctly, and
from here you open up the DTS designer and it can't find
profiles when adding a Send Mail task, then I have no idea.
That sounds like a problem with the mail profile itself but
apparently your SQL Mail and SQL Agent Mail are both working
fine. Pretty much all of the typical issues that cause the
error you report as not being applicable so I haven't a
clue. Other than MAPI just is unreliable crap.
-Sue
On Mon, 14 Aug 2006 11:10:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I'm logging on using service account (MSSQLServer and SQLServerAgent run
>under this account)
>"Sue Hoegemeier" wrote:
>

DTS MAPI profile

I get "Unable to load MAPI profiles" error message in DTS Designer trying to
add "Send Mail" task.
SQLMail has been installed and configured (and tested, it works) on the same
server.
Please help, thank you in advanceWhen in the designer, it's using the current users windows
account and the current users mail profile from the location
or PC where you start up DTS.
Are you opening up the designer while logged onto the server
using the service account or are you doing this from your
PC? If it's from a PC, it doesn't matter what you have setup
on the server.
-Sue
On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:
>I get "Unable to load MAPI profiles" error message in DTS Designer trying to
>add "Send Mail" task.
>SQLMail has been installed and configured (and tested, it works) on the same
>server.
>Please help, thank you in advance|||I'm logging on using service account (MSSQLServer and SQLServerAgent run
under this account)
"Sue Hoegemeier" wrote:
> When in the designer, it's using the current users windows
> account and the current users mail profile from the location
> or PC where you start up DTS.
> Are you opening up the designer while logged onto the server
> using the service account or are you doing this from your
> PC? If it's from a PC, it doesn't matter what you have setup
> on the server.
> -Sue
> On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
> <LeonShargorodsky@.discussions.microsoft.com> wrote:
> >I get "Unable to load MAPI profiles" error message in DTS Designer trying to
> >add "Send Mail" task.
> >SQLMail has been installed and configured (and tested, it works) on the same
> >server.
> >
> >Please help, thank you in advance
>|||If you are logging onto the server directly and logging on
using the service account used by SQL Server and SQL Agent.
And if from here you can see the mail profiles, they have
all been setup, tested and they are working correctly, and
from here you open up the DTS designer and it can't find
profiles when adding a Send Mail task, then I have no idea.
That sounds like a problem with the mail profile itself but
apparently your SQL Mail and SQL Agent Mail are both working
fine. Pretty much all of the typical issues that cause the
error you report as not being applicable so I haven't a
clue. Other than MAPI just is unreliable crap.
-Sue
On Mon, 14 Aug 2006 11:10:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:
>I'm logging on using service account (MSSQLServer and SQLServerAgent run
>under this account)
>"Sue Hoegemeier" wrote:
>> When in the designer, it's using the current users windows
>> account and the current users mail profile from the location
>> or PC where you start up DTS.
>> Are you opening up the designer while logged onto the server
>> using the service account or are you doing this from your
>> PC? If it's from a PC, it doesn't matter what you have setup
>> on the server.
>> -Sue
>> On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
>> <LeonShargorodsky@.discussions.microsoft.com> wrote:
>> >I get "Unable to load MAPI profiles" error message in DTS Designer trying to
>> >add "Send Mail" task.
>> >SQLMail has been installed and configured (and tested, it works) on the same
>> >server.
>> >
>> >Please help, thank you in advance
>>

DTS Mail task breaks after SQL 2005 uninstall/install

When I try to add a Mail Task in my SQL 2000 DTS, I get a message "Please make sure semmap90.dll is installed. When I try to register that dll using regsrv32.exe, it says the entry point is not found.

Any ideas on how to get my e-mail task back?I should point out that I've installed, uninstalled, and then reinstalled SQL 2005 on this machine.|||DTS is now called SQL Server Integration Services. Could you repost this question in the SSIS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1)?|||Go to the 80 directory that's installed with SQL Server 2000 -

(\Microsoft SQL Server\80\Tools\Binn)

Rename the semmap.dll file to semmap90.dll|||

I've been looking for that answer for 3 days now - thank you so much DanaDBA!

--Wil

|||I'm messing around with this more and here's what I've found now -

SQL Server 2005 will not open the DTS package unless you install - Microsoft SQL Server 2000 DTS Designer Components

Once I installed this package, I broke SQL Server 2000

completely. Now I can open the DTS package in 2005, but I'm still

getting some buggy issues. And, now when I reinstall SQL Server 2000,

it will not work.

Make sure you make these changes on a test server. I'll post an update after I get re-configured and test some more.

|||

Ok - I have this working on 2000 and 2005, but I went

through some hurdles to get here.

When I installed the Microsoft SQL Server 2000 DTS Designer

Components, I noticed the \80\Tools\Binn directory had both dll files -

semmap.dll and semmap90.dll (both were not there originally). SQL Server 2000

was throwing tons of errors when loading enterprise manager.

I uninstalled the DTS designer components, still had errors.

I uninstalled and then reinstalled SQL Server 2000. It still would not work

until I applied SP4.

SQL Server 2000 is now working again - now for the DTS mail

issue

When trying to open the send mail task in 2000, I got an

error regarding a missing file-

semmap90.rll (RLL) in this directory. -

C:\Program Files\Microsoft SQL

Server\80\Tools\Binn\Resources\1033

This directory had the semmap.rll file, so I made a copy of

it and then renamed it to semmap90.rll. Now this resources folder has

semmap90.rll and semmap.rll. Both are the same exact files, just different

names.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\

- There should be two dll files in here (semmap.dll and semmap90.dll).

If you do not rename the original semmap.dll to semmap90.dll, prior to

installing the Microsoft SQL Server 2000 DTS Designer Components, you will only

have one of the files (was able to verify this on another system - 2000 SP4,

2005 and the DTS designer components were all installed).

I got this working in a pretty funky way, but it's working.

Not sure at this point what else I may have broken.

Good luck. Email me if you have any questions.

drivkind@.gmail.com

- Dana Rivkind

|||Here's a quick summary of the files and versions I have. Everything still works fine.

I'm running SQL Server 2000, SP4.

This directory needs two DLL's:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\

semmap.dll - (version 2000.80.2039.0)

semmap90.dll - (version 2000.80.194.0)

This directory needs two RLL's (I made a copy of semmap.rll and named it semmap90.rll):

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033

semmap.rll - (version 2000.80.194.0)

semmap90.rll - (version 2000.80.194.0)
- Dana|||Thanks! Note you want to Copy (not rename) but this did the trick!

DTS Mail task breaks after SQL 2005 uninstall/install

When I try to add a Mail Task in my SQL 2000 DTS, I get a message "Please make sure semmap90.dll is installed. When I try to register that dll using regsrv32.exe, it says the entry point is not found.

Any ideas on how to get my e-mail task back?I should point out that I've installed, uninstalled, and then reinstalled SQL 2005 on this machine.|||DTS is now called SQL Server Integration Services. Could you repost this question in the SSIS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1)?|||Go to the 80 directory that's installed with SQL Server 2000 -
(\Microsoft SQL Server\80\Tools\Binn)
Rename the semmap.dll file to semmap90.dll|||

I've been looking for that answer for 3 days now - thank you so much DanaDBA!

--Wil

|||I'm messing around with this more and here's what I've found now -
SQL Server 2005 will not open the DTS package unless you install - Microsoft SQL Server 2000 DTS Designer Components
Once I installed this package, I broke SQL Server 2000 completely. Now I can open the DTS package in 2005, but I'm still getting some buggy issues. And, now when I reinstall SQL Server 2000, it will not work.
Make sure you make these changes on a test server. I'll post an update after I get re-configured and test some more.|||

Ok - I have this working on 2000 and 2005, but I went through some hurdles to get here.

When I installed the Microsoft SQL Server 2000 DTS Designer Components, I noticed the \80\Tools\Binn directory had both dll files - semmap.dll and semmap90.dll (both were not there originally). SQL Server 2000 was throwing tons of errors when loading enterprise manager.

I uninstalled the DTS designer components, still had errors. I uninstalled and then reinstalled SQL Server 2000. It still would not work until I applied SP4.

SQL Server 2000 is now working again - now for the DTS mail issue

When trying to open the send mail task in 2000, I got an error regarding a missing file- semmap90.rll (RLL) in this directory. -
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
This directory had the semmap.rll file, so I made a copy of it and then renamed it to semmap90.rll. Now this resources folder has semmap90.rll and semmap.rll. Both are the same exact files, just different names.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
- There should be two dll files in here (semmap.dll and semmap90.dll). If you do not rename the original semmap.dll to semmap90.dll, prior to installing the Microsoft SQL Server 2000 DTS Designer Components, you will only have one of the files (was able to verify this on another system - 2000 SP4, 2005 and the DTS designer components were all installed).

I got this working in a pretty funky way, but it's working. Not sure at this point what else I may have broken.

Good luck. Email me if you have any questions.

drivkind@.gmail.com

- Dana Rivkind

|||Here's a quick summary of the files and versions I have. Everything still works fine.
I'm running SQL Server 2000, SP4.
This directory needs two DLL's:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
semmap.dll - (version 2000.80.2039.0)
semmap90.dll - (version 2000.80.194.0)
This directory needs two RLL's (I made a copy of semmap.rll and named it semmap90.rll):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
semmap.rll - (version 2000.80.194.0)
semmap90.rll - (version 2000.80.194.0)

- Dana|||Thanks! Note you want to Copy (not rename) but this did the trick!

DTS Mail task breaks after SQL 2005 uninstall/install

When I try to add a Mail Task in my SQL 2000 DTS, I get a message "Please make sure semmap90.dll is installed. When I try to register that dll using regsrv32.exe, it says the entry point is not found.

Any ideas on how to get my e-mail task back?I should point out that I've installed, uninstalled, and then reinstalled SQL 2005 on this machine.|||DTS is now called SQL Server Integration Services. Could you repost this question in the SSIS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1)?|||Go to the 80 directory that's installed with SQL Server 2000 -

(\Microsoft SQL Server\80\Tools\Binn)

Rename the semmap.dll file to semmap90.dll|||

I've been looking for that answer for 3 days now - thank you so much DanaDBA!

--Wil

|||I'm messing around with this more and here's what I've found now -

SQL Server 2005 will not open the DTS package unless you install - Microsoft SQL Server 2000 DTS Designer Components

Once I installed this package, I broke SQL Server 2000

completely. Now I can open the DTS package in 2005, but I'm still

getting some buggy issues. And, now when I reinstall SQL Server 2000,

it will not work.

Make sure you make these changes on a test server. I'll post an update after I get re-configured and test some more.

|||

Ok - I have this working on 2000 and 2005, but I went

through some hurdles to get here.

When I installed the Microsoft SQL Server 2000 DTS Designer

Components, I noticed the \80\Tools\Binn directory had both dll files -

semmap.dll and semmap90.dll (both were not there originally). SQL Server 2000

was throwing tons of errors when loading enterprise manager.

I uninstalled the DTS designer components, still had errors.

I uninstalled and then reinstalled SQL Server 2000. It still would not work

until I applied SP4.

SQL Server 2000 is now working again - now for the DTS mail

issue

When trying to open the send mail task in 2000, I got an

error regarding a missing file-

semmap90.rll (RLL) in this directory. -

C:\Program Files\Microsoft SQL

Server\80\Tools\Binn\Resources\1033

This directory had the semmap.rll file, so I made a copy of

it and then renamed it to semmap90.rll. Now this resources folder has

semmap90.rll and semmap.rll. Both are the same exact files, just different

names.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\

- There should be two dll files in here (semmap.dll and semmap90.dll).

If you do not rename the original semmap.dll to semmap90.dll, prior to

installing the Microsoft SQL Server 2000 DTS Designer Components, you will only

have one of the files (was able to verify this on another system - 2000 SP4,

2005 and the DTS designer components were all installed).

I got this working in a pretty funky way, but it's working.

Not sure at this point what else I may have broken.

Good luck. Email me if you have any questions.

drivkind@.gmail.com

- Dana Rivkind

|||Here's a quick summary of the files and versions I have. Everything still works fine.

I'm running SQL Server 2000, SP4.

This directory needs two DLL's:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\

semmap.dll - (version 2000.80.2039.0)

semmap90.dll - (version 2000.80.194.0)

This directory needs two RLL's (I made a copy of semmap.rll and named it semmap90.rll):

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033

semmap.rll - (version 2000.80.194.0)

semmap90.rll - (version 2000.80.194.0)
- Dana|||Thanks! Note you want to Copy (not rename) but this did the trick!

DTS Looping

DTS Looping
Hi,
I have read articles on DTS looping http://www.sqldts.com/default.aspx?6,103,246,0,1 and a few others, but I still have a problem.

Trying to connect to different Interbase databases via Interbase ODBC driver.
-After connection, use a datapump to select data from db A
-Then loop, based on a global variable that holds the count/ID of the new database B to connect to.

Problem
-GLobal variable successfully getting updated with new branch details
-ODBC driver 'seems' to be switching to new branch db B
-But datapump goes to database A and tries to select the same data again it has done already.
-Loop fails. But if all steps run manually one by one the loop works i.e goes to A then goes to B.

HeeeEEEllLLLppppp !See Attached file for further details|||Hello,
Hoping somebody would have an idea on this one...
Please Help.|||Howdy

Not being a DTS coding expert, I'd suggest adding an extra step in the branch choosing VB script.

If its a timing issue, this will allow the correct value to appear where its supposed to be , ready for the next sweep of the reading program.

Cheers,

SG|||Thanks SG.
Never thought that it could be a timing issue. Will into this.
But found another article on dynamically changing connections in a DTS...
http://www.databasejournal.com/features/mssql/article.php/1461481
Maybe I have luck here.

Question:
Can one call a DTS Package from another DTS Package ?

Thanks again.

Originally posted by sqlguy7777
Howdy

Not being a DTS coding expert, I'd suggest adding an extra step in the branch choosing VB script.

If its a timing issue, this will allow the correct value to appear where its supposed to be , ready for the next sweep of the reading program.

Cheers,

SG|||Still Trying........SO GO ON Sql Experts.take a chance with this one !

Originally posted by bhandp
Thanks SG.
Never thought that it could be a timing issue. Will into this.
But found another article on dynamically changing connections in a DTS...
http://www.databasejournal.com/features/mssql/article.php/1461481
Maybe I have luck here.

Question:
Can one call a DTS Package from another DTS Package ?

Thanks again.|||Originally posted by bhandp
Still Trying........SO GO ON Sql Experts.take a chance with this one !

Are you resetting any database properties within the datapump task? This one quite often trips people up as DTS uses the fully qualified name of the table eg: database.owner.table|||Originally posted by phillcart
Are you resetting any database properties within the datapump task? This one quite often trips people up as DTS uses the fully qualified name of the table eg: database.owner.table

Hi Phill,
How can I give a fully qualified name of a table 'database.owner.table' within the datapump task when my database will change with every time it loops ?
Is there a possibility that, the first database the datapump connects to, remains stored in the datapump ? Here is the script the datapump uses, in its properties:

Function Main()
Dim oPkg, oDataPump, sSQLStatement
Dim FromDt
Dim ToDtLocal

'Assign global variable to local variable
FromDt = DTSGlobalVariables("FromDate").Value
ToDtLocal = DTSGlobalVariables("ToDtLocal").Value

' Build new SQL Statement

sSQLStatement = "SELECT all the fields here"
Where d.updDT >= '"& FromDt &"' " & _
"AND d.updDT < '"& ToDtLocal & "' "

' Get reference to the DataPump Task
Set oPkg = DTSGlobalVariables.Parent
Set oDataPump = oPkg.Tasks("DTSTask_DTSDataPumpTask_1").CustomTask

' Assign SQL Statement to Source of DataPump
oDataPump.SourceSQLStatement = sSQLStatement

' Clean Up
Set oDataPump = Nothing
Set oPkg = Nothing

Main = DTSStepScriptResult_ExecuteTask
End Function

Let me know what you think.
Thanks in advance. Thanks so muchly !
-Parul

DTS Looping

DTS Looping
Hi,
I have read articles on DTS looping http://www.sqldts.com/default.aspx?6,103,246,0,1 and a few others, but I still have a problem.

Trying to connect to different Interbase databases via Interbase ODBC driver.
-After connection, use a datapump to select data from db A
-Then loop, based on a global variable that holds the count/ID of the new database B to connect to.

Problem
-GLobal variable successfully getting updated with new branch details
-ODBC driver 'seems' to be switching to new branch db B
-But datapump goes to database A and tries to select the same data again it has done already.
-Loop fails. But if all steps run manually one by one the loop works i.e goes to A then goes to B.

HeeeEEEllLLLppppp !Hi,
Looks like I have had no luck in this, and nor has anybody else.
Calling all SQL server experts to take a look :)

DTS Looping

Hi to everyone!
It's my first mission in DTS.
I fill global variables with e-mail addresses (maybe with empty string)
of my accounts.
If I have an e-mail(not empty), I need to create an excel file with
data to this account and send messages to him.
I can do it to some alone account, but I have a problem with looping
I saw an example from http://www.sqldts.com/Default.aspx?246
it helped me very much, but when I run it in the loop it dos not
working!
I think a problem in :
stpEnterLoop.DisableStep = False
stpFinished.DisableStep = True
stpEnterLoop.ExecutionStatus = DTSStepExecStat_Waiting
or I do something wrong.
I have 5 ActiveX task. First - fill global variables.
Second starting a loop. Maybe the problem is that i call a second
ActiveX task from itselfe?
Help me please.
Thanks a lot!It's hard to say something without seeing the code (with dts always is the
same) but first of all I'd put a log for that DTS and I'll try to see what
happen.
--
Current location: Alicante (ES)
"Dima" wrote:

> Hi to everyone!
> It's my first mission in DTS.
> I fill global variables with e-mail addresses (maybe with empty string)
> of my accounts.
> If I have an e-mail(not empty), I need to create an excel file with
> data to this account and send messages to him.
> I can do it to some alone account, but I have a problem with looping
> I saw an example from http://www.sqldts.com/Default.aspx?246
> it helped me very much, but when I run it in the loop it dos not
> working!
> I think a problem in :
> stpEnterLoop.DisableStep = False
> stpFinished.DisableStep = True
> stpEnterLoop.ExecutionStatus = DTSStepExecStat_Waiting
> or I do something wrong.
> I have 5 ActiveX task. First - fill global variables.
> Second starting a loop. Maybe the problem is that i call a second
> ActiveX task from itselfe?
> Help me please.
> Thanks a lot!
>

DTS logs and "sysdtssteplog" in msdb

HI,
Does anybody know (maybe from MS) is it safe to remove (truncate table) rows
from the "sysdtssteplog" table with contains DTL step logs?
RedardsYou can delete the logs from Enterprise Manager. Go to Data Transformation
Services, right click in the right pane, and choose 'Package logs...' from
the pop up menu. This will give you a dialog from which you can delete
package logs for all package past and present, and you can delete all the
logs for a package at once as well.
--
Jacco Schalkwijk
SQL Server MVP
"stats12" <vhs180@.polbox.com> wrote in message
news:%231txanRpDHA.2808@.TK2MSFTNGP10.phx.gbl...
> HI,
> Does anybody know (maybe from MS) is it safe to remove (truncate table)
rows
> from the "sysdtssteplog" table with contains DTL step logs?
> Redards
>|||Yes i know, but i must do it manulay for each package.
Now i have 70-ty packages and each is running even 100 times a day.
That's why i'm thinging about some process with wich i would be able to
automatycly clear the DTS logs.
U¿ytkownik "Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> napisa³ w
wiadomo¶ci news:e6y1vsRpDHA.2512@.TK2MSFTNGP09.phx.gbl...
> You can delete the logs from Enterprise Manager. Go to Data Transformation
> Services, right click in the right pane, and choose 'Package logs...' from
> the pop up menu. This will give you a dialog from which you can delete
> package logs for all package past and present, and you can delete all the
> logs for a package at once as well.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "stats12" <vhs180@.polbox.com> wrote in message
> news:%231txanRpDHA.2808@.TK2MSFTNGP10.phx.gbl...
> > HI,
> >
> > Does anybody know (maybe from MS) is it safe to remove (truncate table)
> rows
> > from the "sysdtssteplog" table with contains DTL step logs?
> >
> > Redards
> >
> >
>|||You can create a DTS package with a VBScript task and use the DTS object
model to remove the logs with the PackageSQLServer.RemovePackageLogRecords
method See the article "Retrieving DTS System, Package, and Log Data" in
Books Online for more details.
Undocumented and thus unsupported is the use of the stored procedures that
are called by the above, sp_dump_dtspackagelog and sp_dump_dtslog_all. You
can use these, or have a look at the code of them (they are in the msdb
database), but if something goes wrong with updating system tables directly
like this, you won't have anything to fall back on
--
Jacco Schalkwijk
SQL Server MVP
"stats12" <vhs180@.polbox.com> wrote in message
news:eyJuolSpDHA.3024@.tk2msftngp13.phx.gbl...
> Yes i know, but i must do it manulay for each package.
> Now i have 70-ty packages and each is running even 100 times a day.
> That's why i'm thinging about some process with wich i would be able to
> automatycly clear the DTS logs.
>
> U¿ytkownik "Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> napisa³ w
> wiadomo¶ci news:e6y1vsRpDHA.2512@.TK2MSFTNGP09.phx.gbl...
> > You can delete the logs from Enterprise Manager. Go to Data
Transformation
> > Services, right click in the right pane, and choose 'Package logs...'
from
> > the pop up menu. This will give you a dialog from which you can delete
> > package logs for all package past and present, and you can delete all
the
> > logs for a package at once as well.
> >
> > --
> > Jacco Schalkwijk
> > SQL Server MVP
> >
> >
> > "stats12" <vhs180@.polbox.com> wrote in message
> > news:%231txanRpDHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > HI,
> > >
> > > Does anybody know (maybe from MS) is it safe to remove (truncate
table)
> > rows
> > > from the "sysdtssteplog" table with contains DTL step logs?
> > >
> > > Redards
> > >
> > >
> >
> >
>|||Thank's for the tip with VB and the "PackageSQLServer" object - that's all i
need...
Regards...
U¿ytkownik "Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> napisa³ w
wiadomo¶ci news:eqoiYDTpDHA.392@.TK2MSFTNGP11.phx.gbl...
> You can create a DTS package with a VBScript task and use the DTS object
> model to remove the logs with the PackageSQLServer.RemovePackageLogRecords
> method See the article "Retrieving DTS System, Package, and Log Data" in
> Books Online for more details.
> Undocumented and thus unsupported is the use of the stored procedures that
> are called by the above, sp_dump_dtspackagelog and sp_dump_dtslog_all. You
> can use these, or have a look at the code of them (they are in the msdb
> database), but if something goes wrong with updating system tables
directly
> like this, you won't have anything to fall back on
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "stats12" <vhs180@.polbox.com> wrote in message
> news:eyJuolSpDHA.3024@.tk2msftngp13.phx.gbl...
> > Yes i know, but i must do it manulay for each package.
> > Now i have 70-ty packages and each is running even 100 times a day.
> > That's why i'm thinging about some process with wich i would be able to
> > automatycly clear the DTS logs.
> >
> >
> > U¿ytkownik "Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> napisa³ w
> > wiadomo¶ci news:e6y1vsRpDHA.2512@.TK2MSFTNGP09.phx.gbl...
> > > You can delete the logs from Enterprise Manager. Go to Data
> Transformation
> > > Services, right click in the right pane, and choose 'Package logs...'
> from
> > > the pop up menu. This will give you a dialog from which you can delete
> > > package logs for all package past and present, and you can delete all
> the
> > > logs for a package at once as well.
> > >
> > > --
> > > Jacco Schalkwijk
> > > SQL Server MVP
> > >
> > >
> > > "stats12" <vhs180@.polbox.com> wrote in message
> > > news:%231txanRpDHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > > HI,
> > > >
> > > > Does anybody know (maybe from MS) is it safe to remove (truncate
> table)
> > > rows
> > > > from the "sysdtssteplog" table with contains DTL step logs?
> > > >
> > > > Redards
> > > >
> > > >
> > >
> > >
> >
> >
>

DTS logging in SQL server 2000

Can you plz tel me where all dts information store in sql server 2000.

is it in the master databse in some table

thanks

sandipan

You should try this group for DTS information:

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

If you are saving the DTS packages to the database, they are stored in msdb.

DTS Log Difference

Hi All,
I use the DTSRUN utility with /L option to provide the log filename with
path for logging.
I think in Package property "Error File" option is same as the above but
there the NAME will be given in design time.
Also there is an option to log to SQL Server - MSDB and also to eventlog.
Which method is the best for ERROR Log? Can any one explain with detail or
any website link that explain all that?
Thanks
PrabhatIt depends on who require the data. if the data is being used my
Network/System Administrators then you can log it into Event Log. If Databas
e
Administrators are going to use the data then u log it on MSDB.
If the data is required by the Application Suport Team the u can log it into
a flat file or one of the tables in the Production Database.
Where ever you log the data its one and the same.
hope this answers the question.
thanks and regards
Chandra
"Prabhat" wrote:

> Hi All,
> I use the DTSRUN utility with /L option to provide the log filename with
> path for logging.
> I think in Package property "Error File" option is same as the above but
> there the NAME will be given in design time.
> Also there is an option to log to SQL Server - MSDB and also to eventlog.
> Which method is the best for ERROR Log? Can any one explain with detail or
> any website link that explain all that?
> Thanks
> Prabhat
>
>
>|||Hi Chandra! Thanks for your reply.
Prabhat
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:8EF7A0BC-4391-40C0-A9FB-26A46DF9E14F@.microsoft.com...
> It depends on who require the data. if the data is being used my
> Network/System Administrators then you can log it into Event Log. If
Database
> Administrators are going to use the data then u log it on MSDB.
> If the data is required by the Application Suport Team the u can log it
into
> a flat file or one of the tables in the Production Database.
> Where ever you log the data its one and the same.
> hope this answers the question.
> thanks and regards
> Chandra
>
> "Prabhat" wrote:
>
eventlog.
or|||Good to know that the solution addressed your needs. Really appreciate if yo
u
can rate the Post.
This can be done by answering "Was this post helpful to you?"
"Prabhat" wrote:

> Hi Chandra! Thanks for your reply.
> Prabhat
>
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:8EF7A0BC-4391-40C0-A9FB-26A46DF9E14F@.microsoft.com...
> Database
> into
> eventlog.
> or
>
>|||Hi Chandra,
Yes This Post was answered my question and Helpful to me. Thanks.
Can U please look into my Post "DTS - With Conditions" and Help me in that?
Thanks
Prabhat
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:B1BF847C-25D8-44FE-B082-77D8687FBE0F@.microsoft.com...
> Good to know that the solution addressed your needs. Really appreciate if
you
> can rate the Post.
> This can be done by answering "Was this post helpful to you?"
> "Prabhat" wrote:
>
it
with
but
detail|||Hi Prabhat,
I will try to answer your post "DTS - With Conditions".
for more information on rating the post, please refer to
http://www.microsoft.com/wn3/locale...s.htm#RateAPost
thanks and regards
Chandra
"Prabhat" wrote:

> Hi Chandra,
> Yes This Post was answered my question and Helpful to me. Thanks.
> Can U please look into my Post "DTS - With Conditions" and Help me in that
?
> Thanks
> Prabhat
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:B1BF847C-25D8-44FE-B082-77D8687FBE0F@.microsoft.com...
> you
> it
> with
> but
> detail
>
>