How do I delete excel rows in SSIS?
Is it possible to delete rows in an excel worksheet from SSIS? ...
ssis
T-SQL fuzzy lookup without SSIS?
SSIS 2005/2008 does fuzzy lookups and groupings. Is there a feature that does the same in T-SQL? ...
SSIS Debugging Performance
I’m using SSIS to synchronize data between two databases. I’ve used SSIS and DTS in the past, but I generally write an application for things of this nature (I’m coder and it just comes easier to me). In my package I use a SQL Task that returns about 15,000 rows. I’ve hooked that up to a Foreach Container, and within that I assign the r...
How to migrate from MS Access to SQL server 2005
I have a VB.NET windows application that pulls information from an MS Access database. The primary role of the application is to extract information from Excel files in various formats, standarize the file layout and write that out to csv files. The application uses MS Access as the source for the keys and cross reference files. The w...
How to split a column content using SSIS?
A column is like (000000000000054390- )in the source table which denotes -543.90 .i need the destination as -543.90. How this can be done using ssis ? Thanks Arif ...
Converting DTS packages to SSIS
I'm looking for tutorials or walkthroughs for converting DTS packages into the new SSIS 2005. Any one knows. ...
SSIS: DTS Package Editor fails with: Attempted to read or write protected memory
Hello All I'm trying to migrate some DTS packages from SQL Server 2000 to 2008 to see how much pain is involved. I've got the Standard version of SQL Server 2008 installed on my local machine. I downloaded the Microsoft SQL Server 2000 DTS Designer Components and Microsoft SQL Server 2005 Backward Compatibility Components from msdn ...
Problems moving an SSIS .dtsx package
I've created a dtsx package with Sql Server Business Intelligence Design studio, and I am executing it using the dtexec utility. Via dtexec I am setting certain properties at runtime using the /set switch. So my command looks something like: dtexec /f "mypackage.dtsx" /set \Package.Connections[Destination].Properties[UserName];myUserNam...
Ragged Right text files with many suppressed columns into SQL Server 2005 - SSIS or other tool?
The ragged right flat file option is great for a single trailing field terminated with a CRLF, but when any number of trailing fields which are blank are suppressed and the line terminated early with CRLF, I have found no alternative in SSIS but to read a few columns in with a single "REMAINDER" column and then used a Derived Column tran...
Can you use Sybase.Data.ASEClient.dll .Net Provider with SSIS?
I am trying to create a data connection in SSIS. I have the Sybase.Data.ASEClient.dll version 1.1.680 installed but this does not show as a .Net Provider. Is it possible to use this ADO.NET provider with SSIS and if so how can I make it accessible? ...
Best Place to Store SSIS Sensitive Encrypted Password In a SQL Server Agent Job
I prefer to keep our SSIS packages in a solution on the server, not in sql. By default, sensitive data is encrypted with a user key. Since the sql server agent uses a service account to run jobs, we have to change this encryption method to something else. I like encrypting with a password. The problem is whenever I setup a job in a step...
How to eliminate 'unused output column' warnings in SSIS jobs?
I'm trying to get rid of some spurious warnings in my SSIS Progress log. I'm getting a bunch of warnings about unused columns in tasks that use raw SQL to do their work. I have a Data Flow responsible for archiving data in a staging table prior to loading new data. The Data Flow looks like this: +--------------------+ | OLEDB Source tas...
What are some useful third-party SSIS components (data flow or control flow)?
The number of products out there right now still seems to be slim. ...
Execute a SSIS package FROM VB.NET or C#
I have a SSIS package that eventually I would like to pass parameters too, these parameters will come from a .NET application (VB or C#) so I was curious if anyone knows of how to do this, or better yet a website with helpful hints on how to do it. So basically I want to execute a SSIS package from .NET passing the SSIS package parameter...
SSIS/CSV Architecture question
Hi All, I'm building a series of SSIS packages which will be designed to do the following: 1.) import a few thousand rows from a CSV file into a series of SQL 2005 tables 2.) export a few thousand rows into a series of CSV files I've a few concerns before I dive in: a.) Before I import my csv files, I first want to check that the fil...
Hourly ODBC pull to SQL 2005
I'm trying to pull data from an ODBC app to SQL2005(dev ed) DB on an hourly basis. When I run SSIS the option to import all tables and views is grayed out and forces your to write a query. How would I go about setting up a SSIS integration service to update ALL 250 some tables on an hourly basis. ...
SSIS 2008 - loading excel files selectively.
I have an SSIS package that needs to lookup two different types of excel files, type A and type B and load the data within to two different staging tables, tableA and tableB. The formats of these excel sheets are different and they match their respective tables. I have thought of putting typeA.xls and typeB.xls in two different folders ...
Can I run SSIS packages with SQL Server 2008 Express/Web or Workgroup
I have looked at the SQL Server 2008 feature comparison matrix and it lists the express/web and workgroup editions as having the SSIS runtime. Does this mean it is possible to develop SSIS packages using the developer edition, and then deploy and run them on a server running one of the lowly SQL Server editions such as SQL Server 2008 Ex...
SQL Server Integration Services
What are some recommended resources/books/blogs on SQL Server Integration Services? Thanks. ...
How to step through foreach loop tasks in SSIS
In SSIS, how do I step through a foreach loop in debug to see each step within it individually? I've added breakpoints, but they don't seem to break on them in debug? Thanks! ...