Thanks! it worked.

Any help is appreciated!!

I wrote this expression for the AS400 date in the derived column component to show in the ISO format standard "yyyy-MM-ddThh:nn:ss.fffff"

SUBSTRING(DerivedCol,1,4) + "-" + SUBSTRING(DerivedCol,6,2) + "-" + SUBSTRING(DerivedCol,9,2) +...

I am new to SSIS, can you send me the expression which I can use in the derived column component or refer me to some article. Thanks.

How I can remove the hyphen? Thanks.

How to trouble shoot where the problem is? Any ideas. Thanks.

I have windows 2008, 32-bit OS and SQL Server 2008.

When I am trying to use Execute DTS 2000 Package Task for the purpose of inserting data to AS400, I am...

Any ideas, please!

You can set Min memory to 0.

When we restored the backup's we had some missing data in the database, that might be because of the missing transaction log backups.

So now we are trying to see if...

This script works fine if the table has primary key defined on single column, but it gets complicated if the table has primary key defined on more than one column....

How do I identify the primary key in both the tables, as I will be making a script to check if primary key in the first table is present in...

I want to see if the ordernum of first table if it's present in the second table. Then show the following output:

Dups(Y/N) No.ofDups ColValuethatsDup

The main purpose of...

ALZDBA (2/23/2010)

---

These is one big NONO with your configuration:

Don't set the same value for min and max server memory ! It confuses...

What value shall I assign to the Minimum server memory?

Is the Maximum server memory value okay?

Thanks.