|
More site info...
Discussions in microsoft.public.sqlserver.dts - www.microsoft.com/communities/newsgroups... | Site profile
|
|
Site profile page for http://www.microsoft.com/communities/newsgroups....
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups....
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.microsoft.com/communities/newsgroups... is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) 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 site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Discussions in microsoft.public.sqlserver.dts:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
18
|
34
|
79
|
|
Post:
|
21
|
44
|
115
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.sqlserver.dts (http://www.microsoft.com/communities/newsgroups...)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Discussions in microsoft.public.sqlserver.dts posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.dts Alexa graph:
|
Top authors on Discussions in microsoft.public.sqlserver.dts during last week:
user's latest post:
How to debug packages deployed...
Published (2009-12-02 23:46:00)
Can anyone point me to an example of how to debug packages deployed to SQL Server. I use "Execute Package Task" and the package is located SQL Server. I can debug each package individually. But I would like to debug these packages sequentially without re-deploy to SQL Server in Visual Studio. Regards Maeda .
aspfun via SQLMonster.com
2
user's latest post:
Import huge data from text file...
Published (2009-12-02 14:06:00)
I need to import huge data from text file (3G) with fixed length into a existing SQL table. Can someone give me a hint?
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...
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...
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") ......
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,...
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"...
user's latest post:
DTSRUNUI in 2005 in...
Published (2009-12-02 22:21:00)
Hi I have a DTS package that I can't change that I have exported to a new server runnig SQL 2005. I have installed the package "SQLServer2005_DTS.msi" tha latest one I could find but still cant find DTSRUNUI.exe anywhere on the server. I can find DTSRun.exe in C:\Program Files\Microsoft SQL Server\80\Tools\binn but I need the UI so I can generate teh command line to use in a scheduled job. Is there another...
user's latest post:
SQL Server 2005 SSIS Package...
Published (2009-12-02 14:40:00)
I have several SQL Server 2005 SSIS packages. What tables or t-sql query can I run against the MSDB database to obtain detail information about the SSIS event history? Trying to resolve problems with several SSIS packages. Please help me resolve this issue. Thank You,
|
|
|
Top 10 active forums on Discussions in microsoft.public.sqlserver.dts during last week:
|
|
Top 10 forums on Discussions in microsoft.public.sqlserver.dts:
|
|
|
|
Latest active threads on Discussions in microsoft.public.sqlserver.dts:
Started 1 day, 21 hours ago (2009-12-03 01:31:00)
by Moby
hi maeda
i guess you are talking about logging.
if so, open your package in visual studio, right mouse click, logging
provider type (what i prefer): sql server, add. select the
configuration
for configuration you select a sql db, you use espacially for your
logging. ssis is creating a logging table on it's own....
Started 1 day, 18 hours ago (2009-12-03 04:53:00)
by Todd C
In SSIS, set up a Data Flow with the following:
A Flat File Source and an OLE DB Destination.
=====
Todd C
"aspfun via SQLMonster.com" wrote:
> I need to import huge data from text file (3G) with fixed length into a
> existing SQL table.
> Can someone give me a hint?
>
> --
> Message posted...
Started 1 day, 16 hours ago (2009-12-03 06:56:00)
by alan levy
I've had the same problems when using ssis to AS400 with HIT driver software. Hit wrote back saying this is a know Microsoft bug and the work around is to create individual insert/update strings and execute them on the AS400.
I am still investigating a more viable solution. Appreciate all the help.
Dharmbir Kumar ...
Started 1 day, 18 hours ago (2009-12-03 04:55:00)
by Todd C
It's official name is " Flat File Source" so look at the top of the list, not
at the bottom.
=====
Todd C
"aspfun via SQLMonster.com" wrote:
> I want to import text data into SQL using "import and export wizard".
> There is no text option under the list of data source.
> How to add it?
>
> --...
Started 1 day, 18 hours ago (2009-12-03 04:51:00)
by Todd C
At a command prompt: DTSRUN /?
That will give you hints on all the possible switches.
Also check SQL Server 2000 On-Line Help system.
=====
Todd C
"Brian" wrote:
> Hi
>
> I have a DTS package that I can't change that I have exported to a new
> server runnig SQL 2005. I have installed...
Started 1 day, 18 hours ago (2009-12-03 04:46:00)
by Todd C
Don't know much about custom log providers. Can you pass package variables to
your it? If so, there is one called [System::PackageName].
=====
Todd C
"t. maeda" wrote:
> Hello
>
> I need to get a package name in the Custom Log Provider overrided of
> LogProviderBase class.
> But the ...
Started 1 day, 18 hours ago (2009-12-03 04:44:00)
by Todd C
use MSDB
go
SELECT * FROM sys.tables
WHERE name like '%package%'
That should get you a list of system tables that you can query.
HTH
=====
Todd C
"Joe K." wrote:
>
> I have several SQL Server 2005 SSIS packages. What tables or t-sql query
> can I run against the MSDB ...
Started 4 days, 10 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&...
|
|
Hot threads for last week on Discussions in microsoft.public.sqlserver.dts:
Started 1 day, 21 hours ago (2009-12-03 01:31:00)
by Moby
hi maeda
i guess you are talking about logging.
if so, open your package in visual studio, right mouse click, logging
provider type (what i prefer): sql server, add. select the
configuration
for configuration you select a sql db, you use espacially for your
logging. ssis is creating a logging table on it's own....
Started 1 day, 18 hours ago (2009-12-03 04:53:00)
by Todd C
In SSIS, set up a Data Flow with the following:
A Flat File Source and an OLE DB Destination.
=====
Todd C
"aspfun via SQLMonster.com" wrote:
> I need to import huge data from text file (3G) with fixed length into a
> existing SQL table.
> Can someone give me a hint?
>
> --
> Message posted...
Started 4 days, 10 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&...
Started 1 day, 16 hours ago (2009-12-03 06:56:00)
by alan levy
I've had the same problems when using ssis to AS400 with HIT driver software. Hit wrote back saying this is a know Microsoft bug and the work around is to create individual insert/update strings and execute them on the AS400.
I am still investigating a more viable solution. Appreciate all the help.
Dharmbir Kumar ...
Started 1 day, 18 hours ago (2009-12-03 04:46:00)
by Todd C
Don't know much about custom log providers. Can you pass package variables to
your it? If so, there is one called [System::PackageName].
=====
Todd C
"t. maeda" wrote:
> Hello
>
> I need to get a package name in the Custom Log Provider overrided of
> LogProviderBase class.
> But the ...
Started 1 day, 18 hours ago (2009-12-03 04:51:00)
by Todd C
At a command prompt: DTSRUN /?
That will give you hints on all the possible switches.
Also check SQL Server 2000 On-Line Help system.
=====
Todd C
"Brian" wrote:
> Hi
>
> I have a DTS package that I can't change that I have exported to a new
> server runnig SQL 2005. I have installed...
Started 1 day, 18 hours ago (2009-12-03 04:44:00)
by Todd C
use MSDB
go
SELECT * FROM sys.tables
WHERE name like '%package%'
That should get you a list of system tables that you can query.
HTH
=====
Todd C
"Joe K." wrote:
>
> I have several SQL Server 2005 SSIS packages. What tables or t-sql query
> can I run against the MSDB ...
Started 1 day, 18 hours ago (2009-12-03 04:55:00)
by Todd C
It's official name is "Flat File Source" so look at the top of the list, not
at the bottom.
=====
Todd C
"aspfun via SQLMonster.com" wrote:
> I want to import text data into SQL using "import and export wizard".
> There is no text option under the list of data source.
> How to add it?
>
> --...
|
|
Size: 1,002 bytes
