| Thread | Last Post | Replies |
|
| Where can you view SSIS packages | 31 Aug 2007 17:02 GMT | 3 |
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 GMT | 2 |
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 GMT | 1 |
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.NET | 31 Aug 2007 15:53 GMT | 1 |
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 insertion | 31 Aug 2007 15:34 GMT | 1 |
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 GMT | 1 |
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 SSIS | 30 Aug 2007 23:41 GMT | 3 |
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 Task | 30 Aug 2007 20:18 GMT | 4 |
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 mode | 30 Aug 2007 16:55 GMT | 3 |
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 GMT | 2 |
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 SSIS | 29 Aug 2007 17:58 GMT | 8 |
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 GMT | 3 |
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, missing | 28 Aug 2007 19:00 GMT | 1 |
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 Source | 28 Aug 2007 06:43 GMT | 8 |
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 fails | 26 Aug 2007 16:24 GMT | 2 |
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:
|