need help in SSIS ETL development

by: stant | last post by:

I am trying to call a mainframe cobol DB2 Stored Procedure from an SSIS 2005 SQL Task in BIDS. I believe that privileges and the number of parameters (6) are fine. I've tried casting and still have...

DB2 Database

Programatically running a SSIS package

by: Rodrigo Bellusci | last post by:

IÂ´m using the following code to execute a SSIS package: string pkgLocation; Package pkg; Microsoft.SqlServer.Dts.Runtime.Application app; DTSExecResult pkgResults; pkgLocation =...

.NET Framework

SSIS Import

by: Eric | last post by:

In MS Excel, the ability exists to run a "web query." This function is accessed via the data menu's import external data option. The web query wizard accepts a URL address, and then is able to...

Microsoft SQL Server

Config files problem and SSIS

by: hoots | last post by:

The Problem: I want to be able to use an assembly of an independant application which is not strong named from within an SSIS script component. I have created a wrapper assembly (Utils.dll)...

Visual Basic .NET

Need to insert a header in a tsql select to run in an SSIS package

by: dharper | last post by:

Hi! I'm new to sql 2005 and need to run an automated report that is a fairly simple fixed width ragged right report. Problem is I need a header in the report that has static text, plus the rowcount...

Microsoft SQL Server

ssis EXEC command

by: gelangov | last post by:

I have 2 variables, one is the column name of the table and the other one is the table name and I need to write this in the "Execute SQL task" of a "For each loop" container in a ssis package like...

Microsoft SQL Server

SSIS and DB2 Schemas

by: Mike Martin | last post by:

I have an SSIS package that runs against a DB2 database. It is currently pointing to the development instance. I've tried to make a variable for the scema name, so I can change it when it goes...

DB2 Database

SSIS is pathetic with ODBC connections ...

by: jags_32 | last post by:

We have spent days trying to perform a proof of concept and I am dissappointed with SSIS to say the least. We are trying to connect and fetch data from a Double Byte Progress database and the...

Microsoft SQL Server

FTP in SSIS package failed

by: sam12 | last post by:

Hi Everyone I made a SSIS project in " SQL SERVER business intelligent development Stuidio"which has only a FTP task . When i run this project it doesn't give any error and FTP successfully but...

Microsoft SQL Server

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

VBA Class Basics

by: NeoPa | last post by:

Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

by: isladogs | last post by:

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA

Applying ComboBox filters Sequentially

by: SueHopson | last post by:

Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

Microsoft Access / VBA

Similar topics