|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 DTS Activex ADODB.Recordset Do...Loop and UPDATE via SP is very slow Posted by david.a.karpiak NO[at]SPAM kp.org at 10/6/2006 12:44:28 PM Hello...I'm trying to update a field in a SQL 2000 table with a value
that is extracted from another field within the same table based on a
specific field value ([rectype] value). This value is dependant on a
[rectype] value = 20. All the records in the table that have a
[rectype] of 20 will de...more >>
Unspecified error returned when editing dts pkg containing ftp (copy) Posted by Patricia at 10/6/2006 7:34:23 AM Problem editing SQL Server 2000 DTS Package containing a File Transfer
Protocol task. User can edit SQL Server 2000 DTS package logged in
locally to server but cannot edit same package from her PC via SQL
Server 2000 Client Tools. A co-worker and myself are able to edit the
dts package from ou...more >>
SQL2005 and DB2 Posted by Michael Mogensen at 10/6/2006 5:38:02 AM Using the SSIS I can not locate DB2 OLE DB provider. According to MS it is
included in SQL2005, but where? Do I have to install Client software fro HIS
to get this provider or can it be reached inside the SQL2005 with SP1.?
Any hints?
--
MKM
MCSE,MCT,MCDBA,MCTS,MCITP...more >>
SSIS with an user without sysadmin-right Posted by Joerg Kaukel at 10/6/2006 2:08:01 AM We build a program in C# to run SSIS-packages on SQL Server 2005. This
program generates packages and starts the packages, but the execute on SQL
Server for the packages only works, then the user has the right of sysadmin
on SQL Server 2005.
We found some informations about this problem under...more >>
Migrate Active Script Posted by Stanley at 10/6/2006 12:50:02 AM Could you tell me how to migrate the DTS which has the Active Script included
or do you have any other suggestion for me?
Many thanks,...more >>
Run and Edit DTS in SQL Server 2005 Posted by Stanley at 10/6/2006 12:05:02 AM Hi all,
I've migrated my DTSs to Integration Services but I get an error during the
execution. I've tried to trace the error and edit the DTSs but cannot get in
(no edit menu shown).
Would you tell me where can I get in the edit screen of the DTS?
Many thanks.
...more >>
after changing 'sa' password, dts package fails Posted by Pedja at 10/5/2006 12:19:01 PM Hi,
We have sql server 2000 with sp3. I developed DTS package which contains one
connection object. It is defined to use user account which appropriate
permission in the database. However, when I saved and scheduled the package,
this server was registered in my enterprise manager with 'sa' ac...more >>
How to Install DTS client without EM in 2000 Posted by Adam at 10/5/2006 11:24:02 AM How can I install DTS without having to install Enterprise Manager in SQL
Server 2000?
From the options given through the installation process, it seems I have to
install EM in order to have DTS but my understaning is that DTS is a seperate
client tool which comes with SQL Server. I don't w...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL 2000 - Connection Error with DTS Packages Posted by Andrew at 10/5/2006 9:46:53 AM Up until last night, everything with our production SQL Server was running
just fine, but a few jobs failed and now I have a problem I can't figure
out....
Actually, there were three things that went South last night.... don't know
if any of them relate to my problem, but I'll just state th...more >>
error in sql Posted by SimplySuzy at 10/5/2006 8:07:56 AM Can someone please help me with this syntax error. the single and
double quotes always get me turned around.
I am trying to create a table with a dynamic name set by a global
variable in a dts package
here is me code
Declare @DB varchar(25)
set @DB = 'nfsntest1'
Declare @Tablename varchar...more >>
Error:EXECUTE permission denied on sp_add_dtspackage, database 'msdb', owner 'dbo' Posted by ashtek NO[at]SPAM gmail.com at 10/4/2006 10:11:09 PM Hi,
I am trying to schedule a DTS package which imports data from a remote
server to a local server.
I have left Owner password & User password blank.I have verified that I
have access to the remote server. It is throwing the following error :
EXECUTE permission denied on sp_add_dtspackage, dat...more >>
Calling Stored Procedures within DTS or SSIS Posted by KDogg at 10/4/2006 3:00:01 PM I've tried this both ways but rather new to SSIS:
I have a stored procedure (uspReports) that returns several fields and I
would like to call it within a dts package, take out a specific column
(IncidentNumber) and place that column into a flat file. I am using a temp
table (#TempData) wit...more >>
Transform Data task - using 2 data sources in the Source query Posted by JA at 10/4/2006 12:53:02 PM Hello,
Within the Transform Data Task, I need to query the Source data using
criteria from another data source. That is, within my SQL statement's WHERE
clause, I need to compare a date column from the Source with a date column in
the Destination. How can I do this? Can I use the Lookup ...more >>
Can not see stored Packages using Management Studio Posted by TheMask at 10/4/2006 11:25:02 AM Hi,
I have a SQL 2005 SP1 running SSIS, when I open the SSIS with SSMS the
"Stored Packages" folder is always empty (I can not see the MSDB and File
system sub-folders) Any idea?
...more >>
SSIS variable to Oracle parameter data type error Posted by vnapoli at 10/4/2006 8:31:01 AM I am trying to take a SSIS String type variable and pass it as a parameter to
a varchar2 parameter in an Oracle pl/sql stored procedure and get a binding
error (conneting via Microsoft OLE DB provider for Oracle).
Error Message:
"ORA-01008: not all variables bound.
SSIS variable (...more >>
SSIS 2005, parameter mapping Posted by Truc H. at 10/4/2006 7:38:02 AM Hi,
I created an Execute SQL task.
In the Editor / Parameter mapping,
I added the following parameter :
System::packagename ==> @PkgName
In the SQL text property of the task :
Select col1 From TableName Where PackageName = @PkgName
Parse the query. Got Error message:
"The query faile...more >>
variables in execute SQL task Posted by SQLCat at 10/4/2006 6:42:02 AM I have a DTS job step with the SQL below (abridged). As an example, I want
to take the file name 'mms_datamodules_Oct_Data' and dynamically assign it to
the current month instead of hard coding it each month. How can variables be
used to accomplish this?
CREATE DATABASE [mms_datamodules_n...more >>
DTS Package determine if table is Empty Posted by gavincampbell_uk NO[at]SPAM yahoo.com at 10/4/2006 2:42:39 AM Hi,
I have a dts package that i want to execute and I want to execute a
step as long as the table has records. If the table is empty then i
want the package to stop executing and notify.
Doing a select count(*) from tableName will give me the number of
records and if this is 0 then i know m...more >>
variables in Script task versus Script Component? Posted by artzoop NO[at]SPAM hotmail.com at 10/3/2006 2:20:17 PM Hi,
How do I reference and modify package scope variables in a script
component (within a data flow task)? I tried copying the syntax I used
in a Script task, but got a "Dts" not declared:
Dts.Variables("User::myErrCount").Value = ...
Above works in Control flow Script task, but not with...more >>
DTS problem Posted by hiralkumar ghelani at 10/3/2006 2:06:54 PM i have dts package that contains number of tasks. somewhere in DTS package i
m loading data from oracle to oracle. i have four data trasform tasks. three
data trasform tasks are running fine. but in data trasform task, i m getting
error: 'The number of failing rows exceeds the maximum specified' ...more >>
Task failed in dts package Posted by SimplySuzy at 10/3/2006 1:49:36 PM I have been trying to create an active x script to allow a user to
dynamically create the name of the file by using a dynamically supplied
msgcode, the date and a dynamically filled filename. Here is my code:
Function Main()
'retrieve dynamically set message code
sDB = DTSGlobalVariables...more >>
running dts with xp_cmdshell Posted by arnoled at 10/3/2006 11:54:43 AM I wan't to run a dts with a stored procedure using xp_cmdshell and
dtsrun.
The thing is if i run dtsrun.exe in a command prompt it executes
succesfuly, but if i use xp_cmdshell it gives me the following error:
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259
(80004005)
...more >>
Error executing Cube Via DTS Posted by John at 10/2/2006 10:17:01 PM Hi,
I get the following error when trying to execute a cube via a dts
package when i run it from a remote server that has the sql server tools
installed, but no server, and analysis manager installed. Does anyone know
what I have done wrong?
I am running SQL Server 2000 Sp3a on the da...more >>
No class Microsoft.Sqlserver.dts.pipeline..... Posted by reda246 NO[at]SPAM gmail.com at 10/2/2006 10:05:11 PM Hello,
I would like to ask how to add class
Microsoft.Sqlserver.dts.pipeline.wrapper in script task..
Thank you, Reda
...more >>
executing SSIS remotely Posted by JasonBarton at 10/2/2006 9:41:02 AM Hi all,
I've spent about 3 days trying and hitting dead ends on how to execute an
SSIS package programmatically. Anyway, after failing with SQL Assemblies and
not liking the security work arounds for xp_cmdshell I am down to create a
whole job on the server just to kick off this one SSIS pack...more >>
SQL 2005, ETL Posted by Simon at 10/2/2006 8:21:02 AM Does anyone know type of connection to use to connect to a Fox database table
in ETL. Nothing I try seems to allow me to access the data so I can move it
into a SQL2005 table.
Any help would be great.
Si...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |