I have 100+ child packages and I need to run them in parallel from a parent package. For this I will have to create 100+ Execute Package tasks and then 100+ File Connections. This doesn't look appealing to me and it is repetative and error prone. Is there any other way to do this. Keep two things in mind. Child package Execution should...
Please read Update1 first! This is SSIS specific question. I have the following tasks: I need to periodically move data from table A in MySQL to Table B in MsSQL. Then all of the moved rows needs to be updated in Table A (change a single column value). I have accomplished task 1 by creating the following Data Flow: ADO NET Source ...
I am running Windows Server 2003 R2 Enterprise Edition SP 2 I have created an integration package in VS 2005 which extracts data from Excel and imports it into a table on SQL server 2005 running on this server. The package runs ok in Visual Studio 2005,I did a bit of research which suggests this is due to SQL 64 bit and Windows 64b bi...
I've hit the inevitable state where I have to do a diff on the code within two versions of a SSIS package. What have you used successfully other than what I'm going to do now by opening up 2 instances of VS and go over it box by box and variable by variable? Note: The things that are important to compare in my case are: Variables ...
Hello.. How to convert BlobColumn to String in SSIS Script Component. Ex: Source Column : OrganisationProviderID NVARCHAR(MAX) Destination Column : OrganisationProviderID VARCHAR(20) How can this be acheived in SSIS Script Component Thanks ...
I'm starting to get involved in quite a bit of ETL work a my current job, and everyone seems to be pretty partial to SSIS. I'm struggling trying to do the most trivial transformations through BI studio that would usually equate to a couple foreach loops with a pinch of LINQ. Im not sure of the use cases or users this tool would be usef...
I have a SSIS Package that needs to load data throught oledb component into a table whose name is not known until runtime. In the oledb destination editor I have selected "Data access mode" as "Table name or view name variable". I have entered my "Variable name" that holds the name of the table. When I hit the preview button I am present...
When a certain thing happens in an SSIS job I have running, I need it to send internal messages out to users. What is the easiest way to setup my ASP.NET MVC site so my SSIS service can call some action on the site and pass in a few string parameters (recipients, etc). Should I try and use a traditional web service, or WCF service, or ...
Hi I have a SQL Task that needs to run a simple update to update a single row. I have set the SQLStatement to: update agency set AgencyLastBatchSeqNo = ? where agencyID = ? On the Parameter Mapping page I gave set Parameter 0 and Parameter 1 to variables that I know contain the right values. I have also set the Parameter Name values c...
Hi I know about Integrated Security =True/SSPI is same, but do not know about Persist Security=True Could you please explain Thanks ...
Get substring of a string in ssis script component throw error: Index and length must refer to a location within the string. Parameter name: length at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ScriptMain.Input0_ProcessInputRow(Input0Buffer Row) at Use...
I have a SSIS package which reads an Excel File (Data Flow Source) and transfer the data to SQL Server using OLEDB Destination Data Flow Item.This package is executed by .Net Application using the SSIS Object model. The package stored in a file system within the application subfolder. The package works fine on my development/test machin...
I'm running an SSIS package that I made a few months ago, and ran into an odd error. The package loads data from a tab-delimited file that's exported from an excel worksheet. Errors are redirected to an error table, which is later serialized to an output file. With my most recent attempts to load these files, every row is rejected wit...
Is using SSIS to do reformatting of flat files from one format to another (not using a database; just flat file connections) a common practice, or is it like using a sledgehammer to drive a nail? The reason I ask is that at the company I currently work for we have production personnel (some not too tech-savvy) using an in-house programm...
I'm using dtsx in data migration between two SQL Server instance. One of the table changed the schema by adding a new text field which is not nullable. How can I add defualt value for the field or map it from another table? Thanks! ...
I am using this in Script Component In SSIS--> Microsoft.Office.Interop.Excel.Application objXL = new Microsoft.Office.Interop.Excel.Application(); objXL.DisplayAlerts = false; objXL.Visible = false; Workbook objWorkbook = objXL.Workbooks.Open(strFileNameWithFolderName, false, true, Type.Missing, Type.Mi...
Whats the best way to convert DT_NTEXT to DT_WSTR in Derived Colum Transformation. Regards ...
I have an SSIS package set up like this: If I run only the New Rows flow the Bulk Insert finishes without a problem, but as soon as i connect the Live Rows flow the package stalls indefinitely. When I check the activity monitor the Update Newer Table Rows task stalls, blocked by the Insert New Rows task. Why does the Bulk Insert not ...
I'm pretty familiar with SSIS parsing of regular delimited text data files, however, I'm looking for some advice on an approach to tackle a file that looks like this test file: ISA*00* *00* *01*220220220 *ZZ*RL CODE 01*060327*1212*U*00300*000008859*0*P*:~ GS*RA*CPA-BPT*LOCALUTILITY*060319*1212*970819003*X*003030~ ST*820*000000001~ BPR*C...
Hi, I'm doing data migration between two SQL Server 2008 database using SSIS because I need to do some data transformation. I guess I need to use Business Intelligence Developement Studio which I have on my develop machine. But because I don't have SQL Server Standard Edition on my develop machine. The BIDS do not allow me to build the ...