Profile cover photo
Profile photo
ragini gupta
38 followers -
A ssis and database developer
A ssis and database developer

38 followers
About
Posts

Post has attachment
Synchronous and Asynchronous transformation
Synchronous and Asynchronous
transformation Synchronous
transformation is quicker than asynchronous. But
merge join is faster than lookup sometimes, while merge join is asynchronous. "A asynchronous component requires all the
rows from the upstream componen...
Add a comment...

Post has attachment
ssis package properties
Protection Level Error:  Error: 0xC0202009 at Package, Connection manager "runeet2k8.sa": An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E4D  Description: "Login f...
Add a comment...

Post has attachment
**
Delay validation SSIS validates package to ensure that they will execute properly.Sql server  validation occurs both as package is opened(design time validation) and just before the package executes(run time validation). Design time validation can be perfor...
Add a comment...

Post has attachment
**
Problem- Data Driven
subscription- Not able to create subscriptions for SSRS reports as it give
the following error "Subscriptions cannot be created because the
credentials used to run the report are not stored, or if a linked report, the
link is no longer ...
SQL Server SSIS package
SQL Server SSIS package
ssis-tutorial-online.blogspot.in
Add a comment...

Post has attachment
**
Problem- Data Driven
subscription- Not able to create subscriptions for SSRS reports as it give
the following error "Subscriptions cannot be created because the
credentials used to run the report are not stored, or if a linked report, the
link is no longer ...
SQL Server SSIS package
SQL Server SSIS package
ssis-tutorial-online.blogspot.in
Add a comment...

Post has attachment
**
Problem-
How to connect to MySQL database from SSIS ? Solution- 1.        Either using ODBC driver 2.        Using .Net SQL client Connector Using ODBC Driver- ·          Install newer version of ODBC Driver for
MySQL   ·          ‘Mysql-connector-odbc-5.2....
SQL Server SSIS package
SQL Server SSIS package
ssis-tutorial-online.blogspot.in
Add a comment...

Post has attachment
**
Problem-
How to connect to MySQL database from SSIS ? Solution- 1.        Either using ODBC driver 2.        Using .Net SQL client Connector Using ODBC Driver- ·          Install newer version of ODBC Driver for
MySQL   ·          ‘Mysql-connector-odbc-5.2....
Add a comment...

Post has attachment
Surrogate key
Surrogate key What
is surrogate key? Where
do we use surrogate key? How it
is different from natural key? How do
we implement surrogate key? What
is the advantage of using surrogate key? What
is surrogate key? As its
name suggests, Surrogate means ‘substitu...
Add a comment...

Post has attachment
**
Surrogate key What
is surrogate key? Where
do we use surrogate key? How it
is different from natural key? How do
we implement surrogate key? What
is the advantage of using surrogate key? What
is surrogate key? As its
name suggests, Surrogate means ‘substitu...
Add a comment...

Post has attachment
How to stop any user from dropping any database
How to stop any user from dropping any database you can prevent casual database deletions with a trigger: CREATE TRIGGER STOP_DB_DROP ON ALL SERVER FOR DROP_DATABASE AS PRINT 'You are not allowed to DROP databases' ROLLBACK;
Add a comment...
Wait while more posts are being loaded