sp_who returns only the spid which I am running the query. I can see many spid are opened but those are not listed. Whenever i run it returns only open...

Thanks!!

Hi,

I am trying to run SSIS package using DTEXEC command. While executing the config file is not picked up. Could you please let me know what was the issue here....

Hi,

I am trying to run SSIS package using DTEXEC command. While executing the config file is not picked up. Could you please let me know what was the issue here....

Hi,

I am trying to run SSIS package using DTEXEC command. While executing the config file is not picked up. Could you please let me know what was the issue here....

Balaji (7/3/2009)

Can anyone please post the script component code. I couldnt able to open the solution file.

I am using sql server 2005 and VS 2005

I took the code from the...

Hi,

Can anyone please post the script component code. I couldnt able to open the solution file.

I am using sql server 2005 and VS 2005

I took the code from the article...

I dont thing it will fail if i change the date from '01/01/0001' to '01/01/1753'?

CREATEDT is the source column from DB2 TABLE.

I found the below equivalent option for IIF....

Phil, You are right, In DB2 the least datetime is 01/01/0001 but in Sql Server '01/01/1753' .

Hence we are using the if else statement. My question is how to change...

CREATEDTS is the colulmn from DB2 Server. This is in DATE Format.

Hi,

IIF(TO_CHAR(CREATEDTS)='01/01/0001 00:00:00',to_date('01/01/1753 00:00:00'),CREATEDTS)

The above code works in informatica like below

IF CREATEDTS = '01/01/0001 00:00:00' THEN

CREATEDTS = '01/01/1753 00:00:00'

ELSE

CREATEDTS = CREATEDTS

END

How do u...

Hi Julio,

I got the solution and now its working fine.

Inside the for loop, used execute sql task.

From execute sql task am getting "ConString" value and assigned this to the...

Hi Julio,

The idea is great. Could you please explain further how to implement the logic.

I created Variable in the package called "SourceConString".

Name : SourceConString

Scope : Package1

Data type : String

Value :...

Lutz,

The result is achieved joining tables MAC,INST,DB,TBL. To avoid that I am looking to change the XSD. Declaring DB element attribute as global attribute. In that case I will...

Lutz,

Element "DB" has attributes 'MNM','INM' and 'DBNM'. How do you make these as global attributes.

And "DB" element has its child element 'SOB,TBL,VW,CNST,etc..' I need all the child element should have...