My account: Login | Sign Up
Loading... 

microsoft.public.sqlserver.dts | Forum profile

Forum profile page for microsoft.public.sqlserver.dts on http://www.microsoft.com/communities/newsgroups.... This report page is the aggregated overview from a single forum: microsoft.public.sqlserver.dts, located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "microsoft.public.sqlserver.dts" on the Message Board at http://www.microsoft.com/communities/newsgroups... is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.

Site: Discussions in microsoft.public.sqlserver.dts - microsoft.public.sqlserver.dts (site profile, domain info microsoft.com)
Title: microsoft.public.sqlserver.dts
Url: http://www.microsoft.com/communities/newsgroups...
Users activity: 14 post per thread
Forum activity: 6 active threads during last week
 

Posting activity on microsoft.public.sqlserver.dts:

  Week Month 3 Months
Threads: 6 30 140
Post: 9 38 196
 

microsoft.public.sqlserver.dts Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Transam388
3
user's latest post:
Export one row of a table into a...
Published (2009-01-07 13:58:00)
  Thank you Todd. If I may as this I claim to know not much but I am a little familiar with the Query Analyzer. Two Databases on same server. DB names CEIA and AC. Now we want from DB CEIA, the Table "Users" and row "Photo" to be placed / updated into the AC database in table "Badge" and Row "PIN". Now here is the catch, we want from CEIA, same table but row...
Paddy
2
user's latest post:
SSIS - Web Service Task,...
Published (2009-01-06 04:17:00)
  Didn't think it would help but I have upgraded to SQL 2005 sp3. I have also run tests bypassing our Proxy server. Unfortunately we're still getting this issue. Thanks Pat  
GPage
1
user's latest post:
SSIS vs Linked server in...
Published (2009-01-07 14:13:00)
  I need to pull a table from one server into another for testing purposes. I have a linked server setup from server A to server B and I run a query like this: select col1,col2,col3 into TestTable from server.database.dbo.TestTable There are several million rows in the table and this takes about 45min to an hour to run. If instead I setup an SSIS package to transfer the data and use the bulk insert mode it transfers the data in 7-10...
Todd C
1
user's latest post:
Export one row of a table into a...
Published (2009-01-07 13:46:00)
  This can be done in standard T SQL code: UPDATE d SET d.col1 = s.col1, d.col2=s.col2, . . . d.colN = s.colN FROM <Destination Table> d INNER JOIN <Source Table> s ON d.KeyColumn = s.KeyColumn WHERE s.KeyColumn = <some value> (or something similar) If you are working with data in different databases, (and/or servers), you may need to fully qualify the table name as...
Devivci
1
user's latest post:
ÇõÈqÈVÈ^ÈfÈUÈ_ÈhÈZ È^...
Published (2009-01-06 06:22:00)
  GHEP cU BCP C ECFGC 2008-09!  
Niklas Räsänen
1
user's latest post:
Re: taudit iskee, ihmisiä...
Published (2009-01-05 20:55:00)
  Ydinalan disinformaatiosyydss huomaa aiheen synnyttmn panikin. Totuus ei heit miellyt. Mutta koska haluan varmistaa aina KAIKEN todenperisyyden selvitin mys ne "mystiset" tilanteet, joissa oli mehilisi viel tallessa. Nimittin sellaisia erikoistapauksia yh maassamme ON! Jopa ydinpstkatvealueiden sisll. Juu homma tietysti yliptn on mahdollista, koska mehilisi ja kukkakrpsi ei ole tappaneet mystiset virukset, punkit,...
 

Latest active threads on microsoft.public.sqlserver.dts::

Discussions in microsoft.public.sqlserver.dts
Started 1 day, 11 hours ago (2009-01-07 14:13:00)  by GPage
I need to pull a table from one server into another for testing purposes. I have a linked server setup from server A to server B and I run a query like this: select col1,col2,col3 into TestTable from server.database.dbo.TestTable There are several million rows in the table and this takes about 45min to an hour to run....
Thread:  Show this thread (1 post)   Thread info: SSIS vs Linked server in microsoft.public.sqlserver.dts Size: 1,062 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "SSIS vs Linked server in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 1 day, 13 hours ago (2009-01-07 12:40:00)  by Transam388
Have SQL 2000 and wish to export only a row of data from a particular table but not the whole table itself. Once this is completed then we want to import that data into another DB table and replace the current row data in that table. Now these rows are not named the same thing so this is not a standard same table export / import....
Thread:  Show this thread (4 posts)   Thread info: Export one row of a table into a different DB table row in microsoft.public.sqlserver.dts Size: 1,210 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Export one row of a table into a different DB table row in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 2 days, 19 hours ago (2009-01-06 06:22:00)  by Devivci
ÈGÈHÈEÈP ÈcÈU ÈBÈCÇõÈPÇý ÇöÈCÇ÷ Çü ÈEÈCÇúÇ÷ÇøÈFÈGÇõÈC 2008-09!
Thread:  Show this thread (1 post)   Thread info: ÇõÈqÈVÈ^ÈfÈUÈ_ÈhÈZ È^ È]ÈUÈ`ÈUÈ]ÈqÈWÈUÈ_ÈhÈZ in microsoft.public.sqlserver.dts Size: 563 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "ÇõÈqÈVÈ^ÈfÈUÈ_ÈhÈZ È^ È]ÈUÈ`ÈUÈ]ÈqÈWÈUÈ_ÈhÈZ in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 3 days, 19 hours ago (2009-01-05 06:49:00)  by Paddy
Hi All - new boy here and happy New Year to you... I have a problem I could do with some pointers on. I have an SSIS package to consume a Web Service provided by a 3rd party. This Web Service needs a digital certificate installed to the Personal Store, I have installed this fine and can confirm everything lives where it should....
Thread:  Show this thread (2 posts)   Thread info: SSIS - Web Service Task, Certificates in microsoft.public.sqlserver.dts Size: 1,593 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "SSIS - Web Service Task, Certificates in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 3 days, 5 hours ago (2009-01-05 20:55:00)  by Niklas Räsänen
Ydinalan disinformaatiosyydössä huomaa aiheen synnyttämän panikin. Totuus ei heitä miellytä. Mutta koska haluan varmistaa aina KAIKEN todenperäisyyden selvitin myös ne "mystiset" tilanteet, joissa oli mehiläisiä vielä tallessa. Nimittäin sellaisia erikoistapauksia yhä maassamme ON! Jopa ydinpäästökatvealueiden sisällä. Juu homma tietysti ...
Thread:  Show this thread (1 post)   Thread info: Re: taudit iskee, ihmisiä puskee in microsoft.public.sqlserver.dts Size: 4,386 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "taudit iskee, ihmisiä puskee in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 1 week, 1 day ago (2008-12-31 12:03:00)  by Kelly
When I execute the Transfer Logins Task I get the following error: "[Transfer Logins Task] Error: Execution failed with the following error: "Windows NT user or group '<server>\SQLServer2005SQLAgentUser$<server>$MSSQL SERVER' not found. Check the name again.". " Is there a way to tell this task to not attempt to bring over certain...
Thread:  Show this thread (1 post)   Thread info: Transfer Logins Task in microsoft.public.sqlserver.dts Size: 980 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Transfer Logins Task in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 1 week, 1 day ago (2008-12-31 07:06:00)  by Snowmizer
I am trying to deploy a SSIS package from my computer to a server that is being built to replace an existing server. When I run the .manifest script and select the default deployment path (deploying to SQL Server not File System using Windows Authentication) I get a message: "Could not create the directory "C:\Program Files\...
Thread:  Show this thread (1 post)   Thread info: Deploy SSIS package from remote computer in microsoft.public.sqlserver.dts Size: 1,124 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Deploy SSIS package from remote computer in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 1 week, 3 days ago (2008-12-29 09:15:00)  by KrisC
We create DTS packages on development server and try to move the packages to test servers. We first extract the packages and save them as some kinds of binary files. When we are importing these packages to another servers we have to rename them according to the server name. Now we can only import each package one by one from...
Thread:  Show this thread (1 post)   Thread info: Batch for Transfering multiple DTS packages from one server to another on SQL server 2000. in microsoft.public.sqlserver.dts Size: 1,207 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Batch for Transfering multiple DTS packages from one server to another on SQL server 2000. in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 2 weeks, 2 days ago (2008-12-23 07:56:00)  by Toni
We are currently planing on migrating from SQL server 2000 to SQL Server 2008. I have read that DTS packages will work in SQL Server 2005 but I can not find anywhere if they will work in 2008? Or do we have to convert all of our DTS to SSIS? I have also read there is a tool - Microsoft SQL server DTS Designer components that ...
Thread:  Show this thread (2 posts)   Thread info: SQL 2000 to SQL 2008 DTS/SSIS questions in microsoft.public.sqlserver.dts Size: 1,124 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "SQL 2000 to SQL 2008 DTS/SSIS questions in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 2 weeks, 2 days ago (2008-12-23 08:36:00)  by Yura
Configuration: SQL Server 2005 Std x64, version 9.00.3233 running on Win2003. When trying to edit a Data Flow task of a new or existing (added) SSIS package, the following error is displayed: ------------------------------ Cannot show the editor for this task. ------------------------------ ADDITIONAL ...
Thread:  Show this thread (1 post)   Thread info: Can't edit SSIS DataFlow task (repost in Western encoding) in microsoft.public.sqlserver.dts Size: 1,896 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Can't edit SSIS DataFlow task (repost in Western encoding) in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
 

Hot threads for last week on microsoft.public.sqlserver.dts::

microsoft.public.sqlserver.dts
Started 1 day, 13 hours ago (2009-01-07 12:40:00)  by Transam388
Have SQL 2000 and wish to export only a row of data from a particular table but not the whole table itself. Once this is completed then we want to import that data into another DB table and replace the current row data in that table. Now these rows are not named the same thing so this is not a standard same table export / import....
Thread:  Show this thread (4 posts)   Thread info: Export one row of a table into a different DB table row in microsoft.public.sqlserver.dts Size: 1,210 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Export one row of a table into a different DB table row in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
microsoft.public.sqlserver.dts
Started 3 days, 19 hours ago (2009-01-05 06:49:00)  by Paddy
Hi All - new boy here and happy New Year to you... I have a problem I could do with some pointers on. I have an SSIS package to consume a Web Service provided by a 3rd party. This Web Service needs a digital certificate installed to the Personal Store, I have installed this fine and can confirm everything lives where it should....
Thread:  Show this thread (2 posts)   Thread info: SSIS - Web Service Task, Certificates in microsoft.public.sqlserver.dts Size: 1,593 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "SSIS - Web Service Task, Certificates in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
microsoft.public.sqlserver.dts
Started 1 week, 1 day ago (2008-12-31 12:03:00)  by Kelly
When I execute the Transfer Logins Task I get the following error: "[Transfer Logins Task] Error: Execution failed with the following error: "Windows NT user or group '<server>\SQLServer2005SQLAgentUser$<server>$MSSQL SERVER' not found. Check the name again.". " Is there a way to tell this task to not attempt to bring over certain...
Thread:  Show this thread (1 post)   Thread info: Transfer Logins Task in microsoft.public.sqlserver.dts Size: 980 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Transfer Logins Task in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
microsoft.public.sqlserver.dts
Started 1 week, 1 day ago (2008-12-31 07:06:00)  by Snowmizer
I am trying to deploy a SSIS package from my computer to a server that is being built to replace an existing server. When I run the .manifest script and select the default deployment path (deploying to SQL Server not File System using Windows Authentication) I get a message: "Could not create the directory "C:\Program Files\...
Thread:  Show this thread (1 post)   Thread info: Deploy SSIS package from remote computer in microsoft.public.sqlserver.dts Size: 1,124 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Deploy SSIS package from remote computer in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
microsoft.public.sqlserver.dts
Started 1 day, 11 hours ago (2009-01-07 14:13:00)  by GPage
I need to pull a table from one server into another for testing purposes. I have a linked server setup from server A to server B and I run a query like this: select col1,col2,col3 into TestTable from server.database.dbo.TestTable There are several million rows in the table and this takes about 45min to an hour to run....
Thread:  Show this thread (1 post)   Thread info: SSIS vs Linked server in microsoft.public.sqlserver.dts Size: 1,062 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "SSIS vs Linked server in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
microsoft.public.sqlserver.dts
Started 2 days, 19 hours ago (2009-01-06 06:22:00)  by Devivci
ÈGÈHÈEÈP ÈcÈU ÈBÈCÇõÈPÇý ÇöÈCÇ÷ Çü ÈEÈCÇúÇ÷ÇøÈFÈGÇõÈC 2008-09!
Thread: