Viewing 13 posts - 46 through 58 (of 58 total)
Apologise.
Could you please explain in detail with example.
Thanks
SqlStud
June 6, 2012 at 2:29 am
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...
June 6, 2012 at 1:40 am
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?
(...
June 6, 2012 at 1:17 am
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...
June 6, 2012 at 12:37 am
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?
June 5, 2012 at 11:50 pm
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...
June 5, 2012 at 5:31 am
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 –...
May 24, 2012 at 5:01 am
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...
May 24, 2012 at 4:59 am
Expected result :
GROUP_IDEMP_IDGROUPLIST
101 12011
101 12021
101 ...
May 24, 2012 at 3:52 am
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...
May 24, 2012 at 3:28 am
Viewing 13 posts - 46 through 58 (of 58 total)