Excellent .Good One

Nice Question

Good Question,

I am thinking in different way in terms of table variable even I did not look at not null constraint

Nice Question

Thanks, It is good point

Hi ,

You can use script componet and write the c# or vb script as per requirements

Nice Question

I never use the Ties Option

Thanks

Good Article

Hi

Use the datflow task inside the foreach loop container

Configure the foreachloop enumerator to your folder

Thanks,

Mark

Hi

Connecting to Oracle is not a big deal

Just you have to do down load the client tools on your dev and prod box

Use the ODBC connection to get the...

CREATE TABLE [dbo].[SSIS_RunTimeMetrics](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Load_Date] [datetime] NULL,

[JobName] [varchar](max) COLLATE Latin1_General_CI_AS NULL,

) ON [PRIMARY]

select * from ssis_runtimemetrics

Result:

12012-03-14 00:00:00.000Treasury Extracts Dly

22012-03-14 00:00:00.000Treasury Extracts Dly

32012-03-14 00:00:00.000Treasury Extracts Dly

42012-03-15 00:00:00.000Treasury Extracts...

Hi All,

Thanks for giving the replay

Is there any chance to get order with out order by clause

Hi

First I choosen the C# when I writing the code in c# I got struct

So how will I change the language from c# to vb.net with out removing...

Hi

Thanks Elliott

Hi,

Click the check box(Save password) in connection managers of corrsponding connection