This may not be a direct programming question but I am in desperate need of this and if you people feel that the question is irrelevant , please do close it but after the answer. Like if we visit www.asp.net we will get the videos(free and down loadable) for asp.net, ajax etc.). Likewise, which is the site from where I can get the free...
How big can a SQL Server 2005 SSIS package definition become before design-time or run-time performance is impacted? I'm not talking about the size of the datasets being passed, or even the number of columns being returned. I'm just talking about the number of sequences, tasks, data flow tasks, and variables being used in the package. ...
I frequently encounter a situation in SSIS packages where I run a SQL Command to return a set of rows from an ADO connection. There are cases where I want to branch based on the number of rows returned. The ado resultset is stored in an SSIS 'object' datatype. Is there a way in SSIS expression or Script component to get that count of row...
I'm trying set up an execution account following the steps here: http://msdn.microsoft.com/en-us/library/ms156302.aspx I follow these steps: Start the Reporting Services Configuration tool and connect to the report server instance you want to configure. On the Execution Account page, select Specify an execution account. Type the ac...
SSIS 2005: I have a DataFlow task consisting of an IDataReader source getting zero or more rows from an Oracle data source and pushing those rows to a Script Component being used as a destination. My goal is to load these records into a DataSet, so I override the Script Component's PreExecute method to build the DataSet and the child D...
How can I make identical output from a transformation go to two separate places e.g., an OLE DB destination and a DataReader destination? Background: I have an existing package that reads data from a text file, does some transformations, and loads the data into a SQL Server table. Now I'm trying to make the package be callable from ...
I'm using an oledb data source in an SSIS package to pull a column from a database. The column is XML data type. In SSIS, it is automatically recognized as data type DT_NTEXT. It's going to a script component where I'm trying to load it into a System.Xml.XmlDocument. This is the code that I'm using to get the xml data into a string: Sys...
There is a project in flight at my organization to move customer data and all the associated records (billing transactions, etc) from one database to another, if the customer has not had account activity within a certain timeframe. The total number of rows in all the tables is in the millions. Perhaps 100 million rows, with all the vari...
I'm doing a fuzzy lookup on a view of a table which does a fine job returning similarities with the occasional exception, and I can't seem to figure out what is causing the problem. Every so often, the comparison will come up with null values from the lookup view, even though the values exist in both the view and the original table and t...
I'm converting several large ETL processes from SSIS over to Rhino-Etl. I got fed up with the "grahical programming" nature of SSIS. Hunting through hundreds of dialog boxes to figure out what the ETL process is doing gets old in a hurry. Several of the SSIS packages use the Fuzzy Match component for joining user accounts based on fir...
I am having a problem uploading data from tab-delimited flat files (TSV files) into SQL Server 2005 using the SSIS Data Import wizard. I did not experience this problem using the equivalent procedure in SQL Server 2000, and I have checked that the internal structure of the files I am trying to import is unchanged since well before the SQ...
Hi , I have a problem while executing a SSIS script component. To be honest I am learning SSIS and for the script component, I am going thru The Script Component as a Transformation Article. I have so far done whatever has been stated there . But while I am trying to execute the package, I am encountering the below error TITLE: Package ...
I am considering a tool for an ETL solution that has high daily demand and requires heavy business logic processing. I've tried kettle and SSIS so far, and also want to test for Rhino ETL. I don't care for the visual flow structure of both Kettle and SSIS and creating complex businesse rules seems really hard using them... Rhino ETL seem...
I am copying 120 tables our production database to another location using Transfer SQL Server Object task. I have also tried Script task with VB.NET Script. SQL Server 2005 is the version. All the tables get copied except one table = the error I get is -"The file exists". The table stores files like .doc, .ppt, .xls in a field of data ...
Hi , Sorry to ask this kind of question. If you people feel that it is not 100% technical or is violating the SO rules, please close this but after answering the question. Is there any site that helds SQL Server Integration Services(SSIS) competition? I searched in google(with the string "ssis competition") but with no result. Thanks...
I am trying to convert a package from 2005 to 2008 and am running into some rpblems that seem to be related to synonym lookups. This worked fine in 2005 but for some reason is breaking in 2008, thanks for any assistance. Here is the error text: =================================== Error at Update Existing Assets [Lookup Asset to Make ...
I have a data flow with a derived column. I want to convert the contents of a column using an expression as follows: If the source value is 101 convert it to 1001 If the source value is 102 convert it to 2002 If the source value is 202 convert it to 2019 Etc. It seems like a Switch/Case statement would be ideal here. Do SSIS expressi...
In a Data Flow, I have an Derived Column task. In the expression for one of the columns, I have the following expression: [siteid] == "100" ? "1101" : [siteid] == "110" ? "1001" : [siteid] == "120" ? "2101" : [siteid] == "140" ? "1102" : [siteid] == "210" ? "2001" : [siteid] == "310" ? "3001" : [siteid] This works just fine. However, ...
Every month I get an updated list of USPS ZIP codes, which I dutifully import into my SQL Server 2005 database. It's really a simple process, and during the import process, there's a little tick-box that allows me to "Save as SSIS package". Which, of course, I did. But this is the really crazy part... now that I've saved it - where is...
I am building an SSIS package that will contain dozens of Sequence tasks. Each Sequence task will contain three tasks. One to truncate a destination table and remove indexes on the table, another to import data from a source table, and a third to add back indexes to the destination table. My question is this. I currently have nine of t...