Hi Rs80

I'm afraid you are unable to use LEN function directly, the character_expression argument can be

a DT_WSTR, DT_TEXT, DT_NTEXT, or DT_IMAGE data type.

Try LEN((DT_WSTR,15)([Glbl Amt])) > 0 ?...

Hi Rollercoaster43

Please do following steps:

Start BIDS as user: domainname\some_service, run the package and check the result, you will be sure the job executor account has the right to run this...

Hi A2zwd

Try this:

SELECT [EmpNo]

,[DutyId]

,CAST(FLOOR(CAST([EndDate] as float)) as datetime) as NewDate

,DATEDIFF(hh,[EndDate],CAST(FLOOR(CAST(DATEADD(dd,1,[EndDate]) as float)) as datetime)) as Hrs

...

Hi

Sorry, I didn't express clearly. Of course you are right, It's related but Imho there main problem that it's unable to save the password in the package and deploy it.

Br.

Mike

Hi

Is there any message in job history log?

Br.

Mike

Hi

I'm afraid his problem is not related to the protection method of package.

Please change to Windows authentication mode in connection manager (if mixed mode is on).

Br.

Mike

Hi

Please, check it out: http://blogs.msdn.com/b/florinlazar/archive/2004/03/04/what-is-msdtc-and-why-do-i-need-to-care-about-it.aspx

Regards

Mike

Hi

If you have indexes on destination tables, please drop them before transfer data and create again after.

Keep Identity - by default this setting is unchecked which means the destination table...

Hi

There are a few common problems you might encounter when you run DTS packages as scheduled jobs in SQL Agent:

Relative Path - A relative path (or drive letter) is specific...

Hi

There's no problem run sp, you have to do a few steps:

1. Create a new Data Flow Task.

2. Add OLE DB Source in DFT.

3. Put EXEC "your_sp_name" in SQL Command...

Hi Gila

You have the right to disagree with my opinion, but there is no "right" answer here. For data that is not meant to persist beyond the scope of the...

Hi

Another option, create "Send mail task" in package.

Regards

Mike

Hi Avik

Imho it's hard to give one good advice for you, please try to do some small improvements first.

1. An asterisk (*) is resolved as a reference to all columns...

Hi

You can use UNION operation to combine the results from two queries into single result set.

Regards

Mike

Hi

Did you try:

UPDATE mytable SET mycol = 'new vlaue' WHERE 'col' = 'value'

IF @@ROWCOUNT = 0

RAISERROR('No rows updated',16,1)

Regards

Mike