I am looking for a way to create a script component within SSIS which will accept multiple inputs. I need this so I can do a form of custom joining. It seems really silly that a script can have multiple outputs but only one input, I'm sure I must be doing something wrong. Any help? ...
I have an SSIS script component which takes in rows from input. One of the rows on the input is a boolean which identifies if the row is of type A or B. How do I get the script to load all of the input rows into the correct collection of rows. Also any guides on how to use the row collections and then output them would be great too. ...
I'm currently working on some infrastructure costing, and I'm having a bit of trouble finding the best solution for SQL Server licensing for QA servers. We're developing an ETL solution using SSIS. Our solution doesn't have a database per se, but is utilizing SSIS to run validation and transformation on text files in flight. Because we ...
I have SQL Server 2008 SP1 (64 bit) running SQL Server Integration Services Reporting Services on a Windows 2003 Server (64bit). I'm trying to get Reporting Services to use an integration services package as a datasource. I've created a very simple package that simple reads a text file and loads it into a DataReaderDestination. I ...
Does anybody else have this same problem, when you import data from Excel file to MSSQL Server 2005, if some column contains mostly numeric data, but even if you set the column type to varchar, the wizard fails to import those fields that fail to parse as numbers? ...
Our office uses SQL Server 2000, and by and large it has served our needs well. I'm looking into the possibility of upgrading to SQL 2005 or 2008 because of the new features not found in 2000 (when I saw Index usage statistics which told me which Indexes were the most used and which were never used, that blew me away). I'm not too conc...
I work for a large Canadian retailer, and we're currently considering using CozyRoc for a large ETL project of ours. I was wondering if anyone could recommend the software, ideally through an e-mail chain or over the phone. ...
Is it a good idea to convert complex views in "db1" into tables in "db2" using SSIS. the purpose of converting views to tables is to make the reports faster. Is there any disadvantages or risks? ...
I have a script task in an SSIS package that is supposed to retrieve a string value from the registry. If the registry value exists and has a value in it it appears to return the value fine. If the registry key does not exist or the value is blank, I can not get it to default a value for some reason. I've tried three different ways of...
I am calling a stored procedure from an OLE DB data source in SSIS. Why doesn't SSIS see changes I have made to the stored procedure? It seems like metadata about the stored procedure is cached somewhere. Is it cached? If so how do I force SSIS to see the changes I made to the stored procedure? ...
Hello, I am creating an SSIS package to read in unpacked data from a series of copybook files. I am unsure of the correct interpretation of the following field definitions and was hoping someone would know: FIELD-NAME-1 PIC S9(15)V9(3) COMP-3. FIELD-NAME-2 PIC S9(3)V9(8) COMP-3. FIELD-NAME-3 PIC S9(3)V9(6) COMP-3....
How do I allow an SSIS package to consume a Visual Studio 2005 or 2008 Database project which houses the creation scripts for the tables and other objects (note: this is not Visual Studio Database Edition - just Pro with Business Intelligence)? The idea is to use this to recreate my test instance by building the schema from source safe...
I have make a SSIS package to create xml file,it works fine in studio,but when I try to run in cmd prompt using dtexec /f "C:\OakeyCreek.dtsx" it througs an error SSIS Package "TestOakey" failed with exit code: 1 in the package have sqltask givess resultset as XML and script task for creating xml file. it is working fine in Visual Stud...
Hi I want to create a Log file in SSIS... I know hoe to create through management studio.but i wanted to run my SSIS package through Command Prompt... can you help me to get the DOS commands for that? ...
I've got some sql returning a decimal(20,0) data type. In SSIS I have a package with a foreach loop. In my variable mappings, what type of variable would I map it to? I've tried Int32, Int64, double, and still get the error "The type of the value being assigned to variable "User::iID" differs from the current variable type..." ...
I have 2 tables (~ 4 million rows) that I have to do insert/update actions on matching and unmatching records. I am pretty confused about the method I have to use for incremental load. Should I use Lookup component or new sql server merge statement? and will there be too much performance differences? ...
In SQLServer 2005, is it possible to schedule an SSIS package to run something other than the AQL Agent Service Account? I've got an SSIS package that makes a connection to a db and runs a stored procedure. My criteria is that I will not specify user names/passwords in a package or package configuration, so I want to use integrated au...
I'm using SSIS to import data from Excel sheets into SQL Server 2005, the data contains some columns with data that should have the value of the previous non-empty cell in the same column, it looks like this: 2005 | 15 | Something1 | 12 | Something2 | 14 | Something3 2006 | 10 | Something4 | 2 | Something5 | 18 | So...
Using SQL Server 2005 and Visual Studio 2005, I'm trying to create a SSIS package to merge data from 1 table to several other tables. The source table does not have a several fields that the destination tables do. For example 'CreatedBy' and 'CreatedDate' fields. I would like these to be hard coded (in a sense) as part of the package im...
Hi, I'm trying to use the below command to execute for generating the log file for SSIS package. DTExec /FILE "C:\Documents and Settings\CP0808\My Documents\Test.dtsx" /logger "DTS.LogProviderTextFile;c:\log.txt" But it got the error as below. Please advise. Started: 12:03:20 AM Error: 2009-05-04 12:03:21.15 Code: 0xC001000E ...