Using SQL Server Analysis Services with Sybase Advantage Database Server
Is it possible to use SQL Server 2008 Analysis Services with data stored in Sybase Advantage Database Server? Either directly, or via SQL Server Integration Services. ...
ssis
Version-control in a large SSIS ETL project
We're about to make data transformation from one system to another using SSIS. We are four people people who will continuously be working on this for two years and therefore we need some sort of versioning system. We can not use team foundation. We're currently configuring a SVN server, but digging into it I've seen some big risks. It s...
Subversion lock-modify-unlock solution for SSIS .dtsx
Hello! I wonder how i could set up a developer enviroment for SSIS,.dtsx packages in Subversion? I read about Subversion "svn:needs-lock" property and the ability to set auto-props in a subversion repository by setting "enable-auto-props = yes" in the repository config file. The "svn:needs-lock" property is neccesary when working with...
SSIS - How do I see/set the field types in a Recordset?
I'm looking at an inherited SSIS package, and a stored procedure is sending records to a recordset called USER:NEW_RECORDS. It's of type Object, and the value is System.Object. It is then used for inputting that data to a SQL table. We're getting an error, because it seems that the numeric results of the stored procedure are being put...
how many buffer used by a dataflow in SSIS package?
i have two data flows in my SSIS package,when i execute the package.i want to know the two task will use one buffer area(maybe 10M) or they will use two separate buffer area(each one use 5M) ...
Loop Control within a DataflowTask in ETL
Hi, Being fairly new to SSIS and the ETL process, I was wondering if there is anyway to loop though a record set within a DataFlowTask and pass each row (deriving parameters from the row) into a Stored Procedure (the next step in the ETL phase). Once i have passed the row into the stored procedure, I want the results from each iteratio...
SSIS send email on error sending multiple errors
I have simple SSIS package in which On Error event handler I have created Send email task to send error details. But I get multiple emails for one error. I found the ways to club all emails but they are in vb script and my SQL server is 64 bit which in turn requires hotfix installation for binary compilation. So I need any alternative o...
How to handle added input data colums without having to maintain multiple versions of SSIS packages?
I’m writing to solicit ideas for a solution to an upcoming problem. The product that provides data to our ETL process currently has multiple versions. Our clients are all using some version of the product, but not all use the same version and they will not all be upgraded at the same time. As new versions of the product are rolled o...
How can I use SSIS to create an output row in one table, get the identity from that table for a new row in another table?
Is there a way we can process rows from one input table to two output tables where the first output table has an identity field? We are using SQL Server 2008 SSIS. We need to post the record in the first output table to get the identity field int value to use when posting the second output table's row. The example is Borrower and CoBor...
SSIS XML Decryption Message
My SSIS package says it is successful, but when it runs it ends not doing anything (that I can see). The only thing wrong is this message (that it does not qualify as an error). Description: Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the ...
How to specify a password on the command line of an SSIS package run
I am having an issue where I need to be able to specify the password when I run my packages. This article http://support.microsoft.com/kb/918760 says: Method 3: Set the SSIS Package ProtectionLevel property to EncryptSensitiveWithPassword Change the SSIS Package ProtectionLevel property to EncryptSensitiveWithPassword. This setting u...
how to get external variable value in dtsx package.
Hi, I am executing .dtsx package from c#, it was executing fine, if i am passing one variable value from c# code then how can i get it on .dtsx package for my ole db source query. Here is my c# code. string file = @"D:\CYNCZFuzzy\CYNCZFuzzy\Contact.dtsx"; package = app.LoadPackage(file, null); Variable...
Minimum needs to Deploy SQL Server Integration Services 2008
Hi, I would like to run SSIS 2008 packages on a server that does not have SQL Server 2008 installed on it. I have a simple package to test the concept, but it fails to execute. The return code is 9020 which I have not seen listed as a return code elsewhere. I have copied the following files to the test server that does not have SQL S...
Reading Data from Header in a flat file in SSIS
I have pipe delineated flat file that SSIS is reading in. This flat file has 7 header rows. There is an option to skip (n) number of header rows, but the problem is, is that I need to have the ability to retrieve data from these rows as well. What is the best way of retrieving this this information to be used later in data flow? ...
Excel Source in SSIS Column limitations
Can we import data from Excel with more than 256 fields in to a SQL database using SSIS. If so is there any trick for this, as I couldn’t see more than 255 columns in the column selection at Excel source in SSIS ...
Removing footer from SSIS Flat File
How do you deal with a flat file footer in SSIS? There is an option to get rid of header row(s) but there does not seem to be an (obvious) way to go about removing the footer. In my situation I actually have to remove 19 lines of footer rows from my flat file. I have thought about using a script task to achieve this, but it seems like o...
Compare date fields in SQL server
Hi all, I've a flat file that I cleaned the data out using SSIS, the output looks like that : MEDICAL ADMIT PATIENT PATIENT DATE OF DX REC NO DATE NUMBER NAME DISCHARGE Code DRG # 123613 02/16/09 12413209 MORIBALDI ,GEMMA 02/19/09 428.20 988 130897 01/23/09 12407...
How do I change the server name destination dynamically on a SSIS?
Hi, I have a SSIS that should be execute since the server and invoke since a client. The SSIS copies the data from the server to the client, but the client's name can change, so how can I change the server name destination with the name of the client that invokes the SSIS? Thanks!!! ...
Reading hierarchical flat file into SSIS
I have flat file that structured in a hierarchical format that looks something like this: Area|AreaCode|AreaDescription Region|RegionCode|RegionDescriptoin Zone|ZoneCode|ZoneDescription District|DistrictCode|DistrictDescription Route|RouteCode|RouateDescription Record|Name|Address|Ect RouteFooter Route|RouteCode|RouateDescriptio...
SSIS - How to access a RecordSet variable inside a Script Task
How do you access a RecordSet variable inside a Script Task? ...