I have created a SSIS 2008 Package which imports rows from a spreadsheet. I need to start on row 4 so I have used the OpenRowset property of the Excel connection manager. However, I need to import multiple tables. Can this be done with the Excel Connection Manager? I believe it can be done with an ADO.Net Source, but I don't know how ...
SQL Server 2008 - I want to concatenate four columns into delimited values, but I want them to be ordered alphabetically. Is this possible? *UPDATE:*More info... This will be used on approx 700k-1M rows per day in an ETL job via SSIS. If there is an easier way to do it within SSIS, please let me know (script task, etc). It could also be...
Is it possible setting a password for a ssis package just like we did for dts lagacy packages? I've created a new ssis package but do not know how to set a password for it? ...
Am in process of building my custom component. Am trying to read values of PipleBuffer by GetProperty("propertyname").GetValue() as below: public override void ProcessInput(int inputID, PipelineBuffer buffer) { while (buffer.NextRow()) { string nk = buffer[1].ToString(); string nk1 = buf...
Hi, how to import data from sql server on basis of excel sheet and some master tables in ssis ...
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 ...
Hi, I'm trying to execute a SSIS package on a SQL Server 2008R2. The script retrieve data on a remote server and copy them to its local database. This job is scheduled every hour, the SQL Agent use a proxy to authenticate itself to the remote machine. Authentication seems to be ok but I get an error during loading of the SSIS package. ...
I am using SSIS to grab the results from 2 Views in a SQL Server database, union them (with appropriate mapping), filter them and place them into an Access database. This process is working, but the precisions of certain data are changing. I was already aware of the normal float/real problem of storing approximate values (e.g. http://s...
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, Is it possible to log the events of ssis package execution called from c# Application app = new Application(); Package package = app.LoadPackage("<package_path>", null); package.ImportConfigurationFile("<configuration_path>"); DTSExecResult result = package.Execute(); I need to log the messages generated during the package exe...
HI I am in process of creating an ssis package that need to do following in specified order: 1: process some data 2: move that data to some other tables 3: Get some data and push it in a plain text file. I have created 3 store procedure for these, I have 2 "Execute SQL tasks" for 1 and 2 and a "Data Flow task" for 3rd. Now when i run...
I'm developing an SSIS component and am trying to come up with a way of maintaining a single source code base while building targets for both the 2005 and 2008 versions. I have a two part problem: My project's references for v2005 version point use different .NET DLL's than v2008 (ie, different versions of the same DLLs). A class I us...
I am developing SSIS packages that consist of 2 main steps: Step 1: Grab all sorts of data from existing legacy systems and dump them into a series of staging tables in my database. Step 2: Move the data from my staging tables into a more relational set of tables that I'm using specifically for my project. In step 1 I'm just doing a...
Hi All, I have a case of updating the target table where source columns data not equal to target columns data. I am trying to do this in data flow OLE DB command component but not supporting multiple usage of the columns. I don't want to use the MERGE statement due to the database hits in this business logic. UPDATE targettable set co...
Hi All, I have business scenario as We will get all the data to the database including the duplicates If we have any duplicated in a table take the most recent record from duplicates on perticular key by making all the remaining deplicate records flag to 'X' While processing to the next level filter the extraction by flag != 'X' so we...
Dear All, I have written a task script using vb.net that have thread used in the code, the problem is how i can know when will be finished all the threads so i can return the success result. Thanks alot. ...
From SQL Server 2005, I need to do an export for a client to an xml-like format shown below. Why they are not using XML, I don't know. Any ideas on how to do this quickly without exporting the file "FOR XML" and then writing a messy script to go through the text file and find and replace <, >, and every closing XML tag? Thank you. STA...
How can I configure a dataflow task that takes data from a MS SQL Server 2008 datasource and puts it in an Excel file where the filename looks like 'date filename'.xls? ...
When trying to save my SSIS packages from my vs 2008 to my sql 2008 server. I've lost the option to "Save Copy of Package.dtsx". I have to do some crazy work around that I can't remember ever! Please help me. ...