ssis

SSIS with Sql Server 2005 express

Can we use SSIS with SQL Server (2005) Express as database? ...

SSIS get reference to package

I'm trying to programmatically add an Execute SQL task from within a script task of my SSIS package. I know that the Microsoft.SqlServer.Dts.Runtime.Package class has an Executables collection which I can add my new task to but how to I get a reference to the package Im inside of? ...

debug ssis package - reload InnerPackage.dtsx

Hi all, I used the wizard to build a package that loops through my tables does whatever. It has worked forever and now I have to change it. How on earth do I debug this thing? When I try to run it from bids, it opens InnerPackage.dtsx for editing and then asks me if I want to reload it (since it has changed since the last iteration o...

SSIS location

Where does SQL Server store the SSIS packages? ...

Problem Loading SSIS Custom Connection Manager/Type

I'm currently trying to build a custom connection manager and custom data flow source for a proprietary system at work, and I'm running into an odd problem when I attempt to execute a task containing my custom manager (from BIDS, DTEXEC, or the agent) Error: 0xC0014005 at : The connection type "AF" specified for connection manage...

SSIS package execute - Out-of-memory issue!!

While executing SSIS package, I got following errors, The buffer manager failed a memory allocation call for 10484608 bytes, but was unable to swap out any buffers to relieve memory pressure. 20 buffers were considered and 20 were locked. Either not enough memory is available to the pipeline because not enough are installed, other proc...

SQl server log

Hi, In SSIS packages i want the see the compelete detail of logs like how many rows are inserted throug my packages etc please help me how can i configure it ? ...

lookup task (ssis)

I just need the confirmation. Tell me if I am wrong. A package consists of an oledb source editor which consists of a query followed by three lookups. If I do a preview on each task, every task (oledb source, and the first two lookups) except for the last lookup has values in the respective tables. So, my claim is: if there is no data ...

what happens to the resultset if the lookup table in the lookup task is empty?

Will there be any further resultset to process if the lookup table in the lookup task is empty? sagar ...

Connecting to Oracle from SSIS on Vista 64 bit

I am trying to connect to an Oracle DB using SSIS on Vista 64 bit and getting the following error. "Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client softw...

Powershell in SSIS

What would I need to do in order to run a PowerShell script in an SSIS package? Does PowerShell need to be installed on the SQL server? How do I actually call the script in SSIS? Thanks ...

SSIS Problem reading from flat file

My SSIS program reads as input from a .csv file. The file has about 60,000 rows. And my SSIS package fails during the read, saying cannot convert a certain column due to potential loss of data. Now, I am certain that the majority of the rows are correct. As I have tried pasting random subset of the file and the SSIS reads fine. But I ...

empty lookup table vs non-matching lookup table (lookup transform)

is empty lookup table the same as non-matching lookup table in lookup transform? what would be the result if no row redirection is configured? 1) an empty result set or 2) package failure at the lookup transform ...

Can't build dtproj [SSIS] project in Visual Studio

When I try to build a project in Visual Studio 2005 that has a .dtproj file, I get the error message: Make sure the application for the project type (.dtproj) is installed. This project was build on another system, but even after installing SQL Server 2005 & and SQL SP3, it still does not build. ...

Schedule SSIS Through Web Application

Does anyone know of a good way for a user to be able to specify the schedule for a SSIS package through a web application? The package will run once a day, but the user needs to be able to configure the time that it will run. i.e. every day @ 7am or every day @ 8am etc. ...

how execute SSIS Package on SQL Server 2005 in javascript code???

Hi! I need to execute an SSIS Package on SQL Server 2005 but programing them using the javasript code for a page web. Anybody can help me please?? Thank you! ...

Ignore errors on Data Source in SSIS

I have 3 million rows customers.csv file. When I import it in SQL 2008, I am getting a data source step in a data flow. "[Source - Customers_csv [1]] Error: The column delimiter for column "CCode" was not found." CCode is the last column in the file. The error is on data row 82824. I can't open this 2GB file to look what is going on. ...

Can't import as null value SQL Server 2008 TSV file

I import data from a TSV file with SQL Server 2008. null is replaced by 0 when I confirm a table after import　with integer column. How to import as null, please Help me!! ...

A 99.99 numeric from flat file doesn't want to go in a NUMERIC(4,2)'SQL Server

I have a csv file : 1|1.25 2|23.56 3|58.99 I want to put this value in a SQL Server table with SSIS. I have created my table : CREATE TABLE myTable( ID int, Value numeric(4,2)); My problem is that I have to create a Derived Column Transformation to specify my cast : (DT_NUMERIC,4,2)(REPLACE(Value,".",",")) Otherwise, SSIS don't ...

Tracking down data load performance issues in SSIS package

Are there any ways to determine what the differences in databases are that affect a SSIS package load performance ? I've got a package which loads and does various bits of processing on ~100k records on my laptop database in about 5 minutes Try the same package and same data on the test server, which is a reasonable box in both CPU and...