Latest Power BI and AI articles from RADACAD team
As you may know, there is an enuerator in Foreach Loop Container which help you to loop through files, named File Foreach Enumerator. you can specify a location for searching through files and get files as enuerator in loop.But, there are some times which you need to loop through specific files not all of files Read more about Looping through specific files – SSIS[…]
I wrote about Validation with XML Task in SSIS here before, now I want to write about XSLT in this post. XSLT is an acronym of eXtensible Stylesheet Language Transformation. XSLT can transform given XML document to new style. this is very good way for reading complex XML documents where XML source has week ability Read more about XML Task – Changing Style of Data – XSLT[…]
I decided to explain XML Task for a while. This task has many abilities to work with XML. to use this Task, create a SSIS package , add a XML task ,double click on it, Xml Task Editor window will open.the most important property of XML task is : OperationType .there are 6 OperationTypes in Read more about XML Task – Validating Data[…]
Suppose you have a flat file which is not delimited or fixed width or Ragged right. the structure of data is not well formed for Flat File Connection manager to read, This is an example of data file: date : 04/14/2010customer name : John doeaddress : 2014 apple st. Chicago, IT 30000sale order Read more about How to use Script Component as Asynchronous Transformation[…]
There are lots of times that you need to set your own enumerator in foreach loop container. For example you want to select special sub directories based on specified conditions and then you want to loop through them. so you need to make your own enumerator. so it’s better to create a variable which contains Read more about Foreach Loop based on Variable – SSIS[…]
Problem: you have a table with 2 fields: FilePath -> this field contains address of local image file path FileImage -> this field contains the image exactly, type of this field is image(sql server database) Now you want to update FileImage field with files that are exists in exact local paths. can you do it Read more about Update image column with the physical file with SSIS[…]
I engaged in creating some date expressions yesterday, these expressions are very common needed. So I bring them here to share. Suppose your Date Field name is FillDt , 1- number of days in the quarter of date field. For example If the fillDt is "2002-03-04" Read more about Some useful Date expressions for SSIS[…]
You need to import data from excel file to sql server table, you can do this with a simple import wizard or simple data flow task in SSIS. But there are lots of times which you want to do this data transfer dynamically. Suppose these scenarios: 1- you have many excel files with same structure Read more about Excel to SQL Server, Dynamic Data Flow[…]
Sometimes, you need to use PIVOT in SSIS. brief explanation of what PIVOT is from msdn is here: PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted Read more about PIVOT Transformation – SSIS – Complete Tutorial[…]
Assume .csv file which columns delimited by comma ( , ) . and Texts delimited by Double Quote ( " ) like below: "Invoice Number","Invoice Status","Invoice Date of Service","Invoice Date Opened","Invoice Hold from printing/submission","Invoice Branch","Invoice Balances Adjustments","Invoice Balances Payments","Invoice Balances Balance","Patient Last Name","Patient First Name","Patient ID","Policy Payor Name","Invoice Detail Item ID","Invoice Detail Item Name","Invoice Detail Read more about Problem with comma values in Comma Delimited File[…]