How to find TSQL Code in SSIS Packages
Thu, 7 Aug 2008 15:48:08 -0700
I've got > 300 very complicated SSIS packages which execute TSQL and stored
procedures. SSIS Packages are executed by jobs and some are executed
manually. At various times I have issues with executing spids and need to
hunt down offending code. I can get to the TSQL command via DMV's but how do
I find whi ...
|
New Schedule DTSX Job Fails to execute
Thu, 7 Aug 2008 06:55:16 -0700 (PDT)
I have been having a hell of a time with running a dtsx package on my
SQL server 2005. I designed the package on a development machine and
through Visual studio it runs fine. I then imported the package to my
SQL server Integration services. if I right click on the package and
select execute, I can execute the p ...
|
Delete DTS package from SS 2005 msdb database
Wed, 6 Aug 2008 16:00:36 -0700 (PDT)
G'day,
I have a DTS package that I store in a SS2000 server which I've also
saved into a SS2005 server. I've modified the package using
Enterprise Manager and want to re-save the modified version into the
SS2005 instance but it returns an error: "DTS package '<package name>'
already exists with a different ID ...
|
BI CREATES A COPY OF PACKAGE WHEN OPEN
Tue, 5 Aug 2008 14:49:01 -0700
HI I am only a newby with SSIS so this maybe a simple setting.
I've created a solution in BI with a list of packages.
i work on the solution contineously for a few weeks. After a while when I
open up the solution, click on a package in the SSIS packages list to open, A
copy of the package is created and op ...
|
DTS and MSDE 2000
Mon, 4 Aug 2008 10:24:15 -0700
hello,
attempting to execute a dts pkg. against an MSDE 2000 engine. However,
receiving the following error:
Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or access denied.
Number: -2147467259
MSDE 2000 is not multihomed, so I'm not certain as to why this error is
...
|
RE: can not run dts on sql server 2005
Mon, 04 Aug 2008 15:47:19 GMT
Dear Allan Mitchell,
The above suggested solution worked, now i am able to open maintainance plan in SQL server 2005.
C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll
Thanks a lot
From http://www.developmentnow.com/g/103_2007_6_0_0_989571/can-not-run-dts-on-sql-server-2005.htm
Post ...
|
Certification in Mind???
Sun, 3 Aug 2008 11:46:58 -0700 (PDT)
Hi All,
Certification in Mind???
Visit www.itjobguru.com for Latest Material.
Regards,
Naveen ...
|
|
|
Trying to Copy Data in Text Column
Thu, 31 Jul 2008 09:39:03 -0500
Hi,
I have a table from which I would like to extract 3 text columns in a copy
column data transformation task. I am getting an error: Unspecified Error.
The max error count is set to 0. The SQL version is SS2000 SP4. The relevant
column schema follows.
CREATE TABLE [dbo].[FSCOTraveler] (
[DivisionCode ...
|
global Variables
Thu, 31 Jul 2008 11:14:37 +0100
Can anyone please advise what i am doing wrong, I am trying to pass
variables to a DTS package using the following stored procedure, but the
variables do not look available in the DTS package (********* sensitive
information removed)
CREATE PROCEDURE client_update_jp
@CompId as varchar(20),
@BranId as v ...
|
DSO References
Thu, 31 Jul 2008 01:51:01 -0700
Can i know where can i find any good DSO scripting examples other than MSDN
site
...
|
