Latest Power BI and AI articles from RADACAD team
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[…]
This is common requirement , you need to implement a If condition of If then else condition in a SSIS package flow. The example below illustrated it and implemented it with Precedence Constraints. Problem Scenario: there is a table in sql data source , If any records exist in this table then a Data Flow Read more about Implement If condition in SSIS package[…]
FTP Task is one of SSIS tasks for File Upload,Download or manage ftp file and folders, FTP Task Configuration is easy and all things that must be done is that create a FTP Connection Manager and then set File Transfer configurations. But problem is when you must do this with more than one file, Answer Read more about How to work with multiple files in FTP Task[…]
Did you tried to create a derived column in SSIS with a written sql server function before? This is impossible with Derived Column Transformation because you can not use sql server functions in this transformation. Solution: Use Script Component Transformation. this is a simple example : 1-create a sql server table with 2 fields named Read more about Using Script Component Transformation as SQL Server Function derived column[…]
This is a common problem: Use a dtsx package with dynamic database connection. In fact there are times that you need to set connection string of database from outside of package. solution: Suppose that you have an OLE DB connection and set it to same database which you want to work with and named it Read more about Dynamic connection string in SSIS[…]
Problem: There is a source table and destination table with same structure, but in different databases and different servers . Suppose some of data from source table transferred to destination table in past, and the ID field is not IDENTITY, so all data in destination table has equivalent in source table. Now we want to Read more about How to create NOT IN on different database servers with SSIS package?[…]
Problem: Create a directory based on each year in a specified path, and then create a flat file named with compound of year and month based on a template file. You need to transfer some data into this flat file from a source. The above scenario is a usual scenario when you work with flat Read more about Working with flat files dynamically in SSIS package[…]