|
More site info...
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.
|
|
|
|
|
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:
|
Top authors during last week:
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...
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
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...
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...
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::
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....
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....
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!
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....
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 ...
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...
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\...
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...
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 ...
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 ...
|
|
Hot threads for last week on 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....
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....
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...
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\...
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....
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! | |
Size: 1,062 bytes
