Profile cover photo
Profile photo
shaktisampad Dash
92 followers -
You become what you believe.
You become what you believe.

92 followers
About
shaktisampad's posts

Post has attachment

Post has attachment
Role Playing Dimension in Tabular Model(SSAS)
Role Playing dimension is a single dimension which has multiple references with the fact. Each of these references logically means a different role. Date dimension is the commonly used role playing dimension. The fact dimensions used to have different date ...

Post has attachment

Post has attachment
Triggering a SSIS package by placing a file in a particular location
In SQL server 2012 you can trigger a SSIS package by placing a file in a particular location. This can be done by using a File table feature present in SQL Server 2012. This is a new feature introduced in SQL Server 2012. File Table is a special table where...

Post has attachment

Post has attachment

Post has attachment
How to use fast load option in OLEDB destination?
The common issue in OLEDB destination with fast load option is if some error occurs due to constraint violation the whole batch will fail and it will be redirected to the error flow. In this blog i will show you some work around. Remove all the constrains f...

Post has attachment
Execute SQL Task
Introduction: Execute SQL task is a very common task used inside SSIS packages. As the name says,it can execute a SQL query inside the control flow. How to configure: Execute SQL task is present inside the toolbox in the control flow tab of a package. Drag ...

Post has attachment
Creating connection manager in SSIS
Introduction: Creating a connection manager is the first step of creating a Package and is a very important part. After creating connections only we can do operations inside databases and files. OLEDB Connection: OLEDB connection is required to do any opera...

Post has attachment
Getting started with SSIS
What is ‘SSIS’: ·          SQL Server integration services ( SSIS ) is a tool used to Extract,
Transform and Load ( ETL ) data in
different databases. ·          SSIS is a Microsoft product lunch with SQL
Server 2005. Prior to this it was known as DTS servi...
Wait while more posts are being loaded