Hi All, Could I get ideas on retrieving the dataset using lookup method. Basically, my scenario as I have source data needs to lookup for other source table and on matching column from source I need to get all the records from other source data. its a one to many relations. I tried Lookup but gives only one record on matching condition...
I am attempting to use a lookup transformation in my data transformation package and all of the other lookup transformations went well but one component returns the matching rows only when I enable the partial cache mode. If I use the full cache mode, all data is routed to the error path. I am using SQL 2005 SSIS. Any help appreciated.. ...
What is the correct way of importing data from Excel 2007 file to SQL Server database 2008? The data from excel file should be transferred successfully even if the data in Excel file is changed / replaced with different data except the column name at first row. ...
Hi All, I have a source column with blank (not "NULL"), and target as numeric. while converting using the data conversion it is not converting due to balnk source value so I used derived column to replace a blank value with NULL or 0 as (source column == " ") ? "0" : source column but its not giving the value as 0 in the blank place. ...
Is there any performance when using Script Task rather than other Task controls ? Whether the process will be slow or not ! ...
what is the use of script component in Data Flow ? Is it same as Script Task in Control flow ? Any difference ? ...
I pretty new SQL Server Integration Server (SSIS) user. Is SSIS able to query data from text files located in another Windows Server? I mean that when SSIS is installed on Windwos Server A, is SSIS able to query data from e.g. one folder containing text files in Windows Server B (under same domain)? I have used only SAP BO Data Integrato...
In the script of the script components the Output buffer is not being detected as an existing component. I am trying to use the following piece of code Output0Buffer.AddRow(); within the public override void Input0_ProcessInputRow(Input0Buffer Row) method. I know it should be available within this method because at the moment I am ...
Am attempting to use SSIS flat file source to read a log file being actively written to. Looping and waiting for the file to be released is not practical as this is an active log file held by a service. Ideally, I'm looking for a setting upon the flat file source, similar to the C# code below. If not that, what route can I take to rea...
I am using SSIS to do data transformation from excel to OLEDB SQL. I have a set of sheets in a folder that i ll have to loop thru and insert the data in each of these sheets to a table. I have a scenario where i have to loop thru a set of Excel sheets that has different column structures. I can loop thru each sheet thru foreach loop enum...
I have a farily simple task of taking an Excel sheet and importing it into a SQL 2005 database table. I need to create an SSIS task for this. The Excel sheet does not have all the columns I need to make the insert directly into the permanent sql table, but I know how I could link out to other tables and get the columns that are missing...
Hi All, I have a table with 24 columns of varchar(1000) and 1 column with varchar(8000), my source is of same data lengths of text files. Would I get any problems in the processing due to data lenghs in performance or over size of the sql limit page size. thanks prav ...
I need to pull data from csv file to SQL Server table. Which Control task should I use ? Is it Flat File ? What is the correct method to pull data ? The problem is I have used Flat File Task for pulling csv file. But the csv file whihc I am having, contains headings as first row, then on the third row, I have the columns, and data start...
I have 700k-1M rows coming in with a comma delimited field (among others). I need to keep this column intact, but sort the rows so that I can determine duplicates. In this business case, a,3,null,40 is the same as null,40,a,3 and so on. This can be achieved via stored proc, script component, tsql. I found this component which does exa...
Hi I am trying to connect Oracle 10g(Source/Target) from ssis using connection string as Data Source=Qrgo;User ID=sy;password=sa;Provider=MSDAORA.1; Qrgo is Servicename getting error Test connection failed because of an error in initializing provider. ORA-12520: TNS:listener could not find available handler for requested type of server ...
From within SSIS, {t}, {CR}, {LF}, and {CR}{LF} are listed in the dropdown of row and column delimiters. I was wondering if there are other nomenclatures using the braces notation for non-printable characters? I've tried the following without success: {bell} - bell {b} - backspace {^^} - column delimiter control character ...
Hi guys, Hope u guys help me. Actuall I want to migrate from Access Database to SQL Server which has better structured table. Suggest me a solution to do the following. I have source table as follows Table_Source(EmployeeNo,Fever,Cold,HeadAche) - So if a person is having fever the column will be marked as true. Employee can have mu...
What is the purpose of Derived Column Task ? ...
What are the purpose for Merge and Merge join Tasks in Data Flow ? ...
I wanted to convert DateTime data which will be pulled from source, to Date format only or I want to retrieve only Date with no time. How is it to be done here ? Also how is to be done for converting the Datetime data for a customised format while pulling from the source ? ...