Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
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: 15 post per thread
Forum activity: 4 active threads during last week
 

Posting activity on microsoft.public.sqlserver.dts:

  Week Month 3 Months
Threads: 4 20 68
Post: 5 28 102
 

microsoft.public.sqlserver.dts Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
BrendanDowns
1
user's latest post:
Importing text files via DTS...
Published (2009-11-24 15:00:00)
  I am trying to import a fix length text file in database table using DTS under SQL Enterprise Manger v8.0. The text file has 360 fields and a total record length of 5500 characters. The largest field is 100 characters. There are also 1.1 million records in the file. When trying to define field positions on the "Text File Properties / Fixed Field Column Positions" screen I cannot define field positions past...
taariq
1
user's latest post:
SSIS date format problem in...
Published (2009-11-26 21:56:00)
  Hi I have a big problem with an SSIS package. First of all it’s running on a windows server 2003, SQL server 2005 and Office 2003. The package is responsible for exporting data from a database to an excel sheet. There is a field date which has been converted in the format DD/MM/YYYY in the SQL. When I test the query in SQL server I got the right date format and also when I run the package via the SQL server business intelligent...
Joachim Hofmann
1
user's latest post:
ActiveX -> VB.Net Scripttask...
Published (2009-11-27 07:56:00)
  Hello, I migrated a DTS-Package to SSIS. There is an ActiveX-Task in vbscript I d like to rewrite in a new VB.Net Scripttask. The task sets the datasource of flatfile connections dynamically by prompting the user and setting the datasource property. Set oPackage = DTSGlobalVariables.parent ... strPromptedPath = InputBox ("Where are the files?", "Import Post-CD") ......
Nigel
1
user's latest post:
SQLServer 2005 DTS in...
Published (2009-11-30 04:36:00)
  We have 2 SQLServers 2005 std, both on windows 2003 servers 64 bit. On one server the DTS works fine but on another the following error appears; SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. If the "SQL Server 2000 DTS Designer Components" download is already installed,...
Russell Fields
1
user's latest post:
SQLServer 2005 DTS in...
Published (2009-11-30 12:46:00)
  nigel, I believe that you also need to install the "Microsoft SQL Server 2005 Backward Compatibility Components" which can be found at the same download location as the "Microsoft SQL Server 2000 DTS Designer Components", namely: http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en Hope that helps, RLF "nigel"...
 

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

Discussions in microsoft.public.sqlserver.dts
Started 2 days, 15 hours ago (2009-11-30 12:46:00)  by Russell Fields
nigel, I believe that you also need to install the "Microsoft SQL Server 2005 Backward Compatibility Components" which can be found at the same download location as the "Microsoft SQL Server 2000 DTS Designer Components", namely: http://www.microsoft.com/downloads/details.aspx?fa milyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&...
Thread:  Show this thread (2 posts)   Thread info: SQLServer 2005 DTS in microsoft.public.sqlserver.dts Size: 2,527 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SQLServer 2005 DTS in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 2 weeks, 1 day ago (2009-11-17 05:47:00)  by Todd C
Ryan: Are you placing your script task on the Control Flow, or in a Data Flow? I think it makes a difference which Imports statements the Script adds automatically. Try one of each and examine the pre-defined parts. HTH ===== Todd C "Ryan Gomez" wrote: > Hi all, > > I'm a SSIS ...
Thread:  Show this thread (2 posts)   Thread info: Name 'Dts' not declared. in microsoft.public.sqlserver.dts Size: 2,906 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Name 'Dts' not declared. 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 (2009-11-16 21:49:00)  by Todd C
Hello: Visual Studio 2005 and 2008 should be able to co-exist on a single workstation without interference. I have had both versions on mine for about a year now. When you re-installed SQL 2005, did you select the Designer Tools? That should do it. ===== Todd C "richard.hunt" wrote: > So ...
Thread:  Show this thread (2 posts)   Thread info: SSIS 2008 converted SSIS 2005 in microsoft.public.sqlserver.dts Size: 1,079 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SSIS 2008 converted SSIS 2005 in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 2 weeks, 5 days ago (2009-11-13 09:01:00)  by Carlos Cruz
Cindy, I have the same problem, there is a solution, In the OLE DB Destination component, in the Mappings option in the input column you must choose the Data Conversion.[COLUMN_NAME], and that's it. Carlos. Angus wrote: I have run into this as well. 11-oct-07 I have run into this as well. When you ...
Thread:  Show this thread (2 posts)   Thread info: cannot convert between unicode and non-unicode string data types in
microsoft.public.sqlserver.dts Size: 8,837 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: cannot convert between unicode and non-unicode string data types in
microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"
Discussions in microsoft.public.sqlserver.dts
Started 2 weeks, 6 days ago (2009-11-12 08:10:00)  by Todd C
Yes, Most definitely. And Developer Edition. NOT available in SQL Express, though. ===== Todd C "Ilya" wrote: > is SSIS available SQL Server 2005 Standard Edition? > -- > Ilya
Thread:  Show this thread (2 posts)   Thread info: iSSIS in SQL Server 2005 Standard Edition in microsoft.public.sqlserver.dts Size: 613 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: iSSIS in SQL Server 2005 Standard Edition 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 2 days, 15 hours ago (2009-11-30 12:46:00)  by Russell Fields
nigel, I believe that you also need to install the "Microsoft SQL Server 2005 Backward Compatibility Components" which can be found at the same download location as the "Microsoft SQL Server 2000 DTS Designer Components", namely: http://www.microsoft.com/downloads/details.aspx?fa milyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&...
Thread:  Show this thread (2 posts)   Thread info: SQLServer 2005 DTS in microsoft.public.sqlserver.dts Size: 2,527 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SQLServer 2005 DTS in microsoft.public.sqlserver.dts :: microsoft.public.sqlserver.dts :: Discussions in microsoft.public.sqlserver.dts"