Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / DTS / August 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Where can you view SSIS packages31 Aug 2007 17:02 GMT3
             where can I view what SSIS packages are installed on a server?
SQL Server Agent Job launching Parent-child packages...31 Aug 2007 16:16 GMT2
Does anyone know why when launching a package containing a child package from
a SQL Server Agent job, the parent package launches correctly but the child
package does not?
Any help or direction is greatly appreciated.
DTS Package send DTS Package error via e-mail.31 Aug 2007 15:59 GMT1
When a step in my DTS Package fails, it would be nice if the actual
DTS error  could be e-mailed.
Is this possible?  How would I go about doing this?
Thanks,
Questions concerning SSIS and VB.NET31 Aug 2007 15:53 GMT1
First, let me quickly say that, so far, this is the best, most concentrated
site I have found with worthwhile information concerning SSIS.  Kudos to all
who have contributed.
My questions:  I'm still trying to get up to speed with SSIS. (I liked DTS,
Unable to prepare the SSIS bulk insert for data insertion31 Aug 2007 15:34 GMT1
I have a client that is getting the error "Unable to prepare the SSIS bulk
insert for data insertion".  The Sql Server is the same server as the SSIS
package and I have
changed my connection type from SQL Server to OLE DB with still get the
ssis password - child / sub packages.31 Aug 2007 15:28 GMT1
There is a master package with several child packages. The encryption i have
is
EncryptSensitiveWithPassword. Is there a way i can set the password
dynamically using configuration file or parent variable . I see no option to
DTS vs SSIS30 Aug 2007 23:41 GMT3
I have access to a shared SQL 2005 server. So far, I cannot save my first
SSIS package due to an execute permisison error. I'm assuming it's a rights
issue and will get resolved.
In the interim, I'm trying to get up to speed with the differences between
SQL Server 2000 - Parameters in a Transform Data Task30 Aug 2007 20:18 GMT4
I need to create a text file with data from a table. No problem, I've done
that before. Then I discovered I need to select rows based upon a parameter.
Still no problem, I know how to pass parameters to a DTS package with DTSRUN.
I created a package with:
executing packages in 32bit mode30 Aug 2007 16:55 GMT3
I'm currently experiencing the following error when running one of my
packages:
Error: 2007-08-27 13:52:43.91
  Code: 0xC0202009
Where is SSIS?30 Aug 2007 16:09 GMT2
             I have SQL 2005 Express and cannot find SSIS.  I can save a
package from the Import Export wizard, but cannot see anywhere where you can
view or design packages.  I have even downloaded DTS for 2005 from
Microsoft, but still cannot find a way of designing packages.  ...
storing password in SSIS29 Aug 2007 17:58 GMT8
My source connection is a SQL Server in SSIS and I use SQL Authentication. So
I provide the user id and password in the source connection. When I check the
object into Source safe and check it out, tha password is not saved. This was
never a problem in the DTS world. Also, I dont ...
Calling a package within a package...29 Aug 2007 17:52 GMT3
I have a package that calls another package using the "Execute Package
Task".  When I execute the parent package from BIDS or designer, the parent
package calls the child package without a problem.  If I execute the package
from a SQL Server Agent job, the child package does not ...
Migrated DTS Packages to 2005, missing28 Aug 2007 19:00 GMT1
I went through the Migration Wizard.  Management -> Legacy -> Right click on
Data Transformation Services.  I just want to migrate a simple DTS package
that copies objects from one database to another.  When I run through the
wizard, it runs successful; however when I go to ...
Filter data in OLE DB Source28 Aug 2007 06:43 GMT8
I'd like to filter data in the OLE DB Source node based on a variable value,
to realize the function simliar to "SELECT * FROM Table WHERE Col1=@var1".
But it appears to me that the only way I can do this is manually structure a
sql statement in a Script Task node and execute it ...
Execute DTS 2000 Package in SQL 2005 fails26 Aug 2007 16:24 GMT2
Hi.  I have a simple DTS package that runs fine on a SQL 2000 server.  But
when I try to run it from within a SSIS parent package, it fails with:
SSIS package "CopyFundWareTables.dtsx" starting.
Error: 0x0 at Execute DTS 2000 Package Task:
Pages: 1 2 3 4 July, 2007
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.