Thanks Rock

🙂

Apologise.

Could you please explain in detail with example.

Thanks

SqlStud

Thanks Rock.

I have the below Configuredvalue in SQL server table for config

Data Source=Sample_Dev;Initial Catalog=Medical_Loss;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Packet Size=32767;Application Name=SSIS-Load OAM_Data-{C1404D63-52E4-4629-86C5-7CF476146C02} Sample_Dev. Medical_Loss;

Dev Server : Sample_Dev

Db Name : Medical_Loss

If we update the...

Thanks Rock.

That means, if we update the table to Dev, it will execute it in Dev environment and update the tabel to test, it will execute it in Test environment?

(...

Thanks Rock..

But i need to use it in different environments ie Dev and Test etc...

How can we pointing to different environments?

If we run the package, it should take the corresponding...

Is it necessary to use XML config or Environment variable? Without using them, is there any other way to use SQL Server table for setting configuration?

Thanks shailesh thapliyal

🙂

Thanks Suresh.

But i need to set the config file from SQL Server.

Inserted the config script in Sample_Config table.

Done the following things.

Package Configuration -----? Right Click -----------?(Wizard Opened) Selected Config Type...

Thanks for your Prompt Reply.

🙂

Sorry for the mistake

Please read it as

Record #1 to Record #2 – GROUPLIST will be 1.

Record #3 to Record #4 – GROUPLIST will be 2.

Record #5 to Record #6 –...

Thanks for your prompt Reply.

But thing is that we need to split the total records into 4 batch as per each GROUP_ID.

In our example, total records for GROUP_ID = 101...

Expected result :

GROUP_IDEMP_IDGROUPLIST

101 12011

101 12021

101 ...

Please find the table queries and data

/* Create tables */

CREATE TABLE [dbo].[EMP_REC](

[GROUP_ID] [varchar](10) NULL,

[EMP_ID] [varchar](10) NULL,

[EMP_NAME] [varchar](35) NULL

)

CREATE TABLE [dbo].[EMP_SUMMARY](

[GROUP_ID] [varchar](10) NULL,

[EMP_ID] [varchar](10) NULL,

[GROUPLIST] [varchar](35) NULL

)

/* Insert tables...