Topic profile page for DTS Package.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: DTS Package.
Topic "Dts package" was discussed 0 times on 0 sites in last 3 months
Started 4 days, 3 hours ago (2009-12-22 16:59:00)
by Watson78
I am trying to run a sql statement as part of a DTS package. I've tried variations of the following: Update tblPlayers Set tblPlayers.IsNoMail ='-1' From tblPlayers inner join NCOABad on tblplayers.acct =NCOABad.acct GO Basically, I have imported an excel sheet of bad addresses into the database in the first steps of the package, and now I want to update another table to mark these ...
Started 4 days, 11 hours ago (2009-12-22 08:58:00)
by Watson78
I am trying to run a sql statement as part of a DTS package. I've tried variations of the following: Update tblPlayers Set tblPlayers.IsNoMail ='-1' From tblPlayers inner join NCOABad on tblplayers.acct =NCOABad.acct GO Basically, I have imported an excel sheet of bad addresses into the database in the first ...
Started 1 week, 1 day ago (2009-12-18 16:40:00)
by Rakoczy
Hi All, I am creating a simple C# 2008 Application which will run a DTS Package on a SQL Server 2000. The Package takes data on an external computer, and places it into a Database Table. After some fighting with code, as seen below, I got the majority to work. I am able to view all the Package info (such as name, date created, etc), however when the code reaches the Package.Execute() command...
Started 1 week, 2 days ago (2009-12-17 17:08:00)
by Ed Leighton-Dick
I recently installed SQL 2008 Management Studio on a new Windows 7 computer and upgraded it to SP1 CU5. I followed the instructions on http://msdn.microsoft.com/en-us/library/ms143755.a spx (including the section under "To ensure that the DTS designer can be used in SQL Server Management Studio") to install the backward compatibility components and DTS designer components so I can edit my DTS ...
Started 2 weeks, 2 days ago (2009-12-10 04:36:00)
by Craig Lister
I have a requirement to import data from one SQL Server (2005) database, to another, transforming the data on the way through. So, DTS seems to fit that requirement perfectly. My problem is, how to lanch that DTS package. Source database gets populated, and then as soon as possible, we need to start importing from that database. The data in the source is actually pumped in via a 3rd party. They ...
Started 2 weeks, 2 days ago (2009-12-09 21:16:00)
by Craig Lister
I have a requirement to import data from one SQL Server (2005) database, to another, transforming the data on the way through. So, DTS seems to fit that requirement perfectly. My problem is, how to lanch that DTS package. Source database gets populated, and then as soon as possible, we need to start importing from that database. ...
Started 3 weeks ago (2009-12-05 11:09:00)
by J. Mitchell
I've got a DTS package that imports data into a table in SQL Server. I want to modify it to run a validation script which returns an integer. If this integer is greater than 1 I want it to send a warning email. How would I set that up? I've not managed to figure it out yet but I'm sure it's fairly straight forward!
Started 3 weeks, 5 days ago (2009-11-30 11:34:00)
by Jinto Varghese
I am running into issues when running the "DW Import" DTS package to load my datawarehouse database from the Commerce Server databases. The package, as we know, has seven tasks. However the first task in the package " Configuration Synchronization " always fails for me with the following error being logged into the error log file: Step 'DTSStep_CS_DTSSyncAdm.DTSSyncAdminData' failed Step ...
Started 1 month ago (2009-11-23 18:22:00)
by Parthik Parikh
How Can I transfer Tables from One Server, Database to another server,database using Dynamic Properties task (Configuration files) or Global Variables. The table schema needs to copy first from the source server to Destination Server and then the data needs to be copied. I tried two different way but I couldn't figure out how to dynamically get the table schema and create the table definition ...
Started 1 month, 2 weeks ago (2009-11-10 14:12:00)
by ashleybyrdnc
I was able to import my tables into MS SQl 2005 and they will drop and create. When when I try to run them again on a schedule they will not work. Nor can I run them manually agian. But everytime I reimport them they work the first time. here is my error log. Can anyone please help me. Date 11/10/2009 1:42:50 PM Log Job History (APCOPAF) Step ID 1 Server CLR-...
Started 4 days, 2 hours ago (2009-12-22 17:53:00)
by Todd C
Try executing the command by itself inside SQL Server Management Studio. What is the data type of field [IsNoMail] ? If Boolean (bit) then 0 = False and 1 = True. (Yeah, I know, not pure boolean logic, but hey, it's Microsoft and THEY decide). If it's integer, try removing the single quotes: Set tblPlayers.IsNoMail = -1 Hope this help. If so, please post a quick response because I don't ...
Started 1 week, 1 day ago (2009-12-18 03:00:00)
by Alberto Morillo
Hello, Please follow the procedure given in the following link: http://blogs.msdn.com/sqlserverfaq/archive/2009/07 /09/error-sql-server-2000-dts-designer-components- are-required-to-edit-dts-packages-install-the-spec ial-web-download-sql-server-2000-dts-designer-comp onents-to-use-this-feature-microsoft-sqlserver-dts objectexplorerui-ssms.aspx Hope this helps. Regards, ...
Started 4 days, 11 hours ago (2009-12-22 09:52:00)
by Todd C
Try executing the command by itself inside SQL Server Management Studio. What is the data type of field [IsNoMail] ? If Boolean (bit) then 0 = False and 1 = True. (Yeah, I know, not pure boolean logic, but hey, it's Microsoft and THEY decide). If it's integer, try removing the single quotes: Set tblPlayers.IsNoMail = -1...
