I think I'm not experiencing the issue because of the large data sets as I initially thought but because of the larger list size. I'm wondering if changing the Daily...

Thanks for the response Steve!

It happens only sometimes and I think only when trying to pull large data sets. Could you please tell how can I change the timeout settings...

Hi,

I have the following Oracle Client installed on my machine. I'm able to connect to the server with SQLPLUS. The problem is only when trying to create an OLE DB...

Vikas/Bru, Thanks for responding!

Yes. I don't want the result set in spread sheet or any other file. I want the result set to be sent in email message body. Unfortunately,...

I'm actually looking for my DTS package being able to send the result set, pulled by a SELECT statement inside the ExecuteSQL package, in an email with SMTP mail task...

True. It worked after adding Password parameter. Thanks!

Could anyone please tell me if a partition table can use identity column. Also, can foreign keys refer the partition table.

Thanks,

-Amith Vemuganti

Thanks for the link Noel! Could you tell me how I can move the existing non-partitioned table to a partitioned scheme. I read an article saying we can do that...

Thanks for the Reply. Unfortunately that doesn't seem to be working. Could you explain me in detail how can I do this. Here is the scenario:

I have a Parent Package...

Thanks for the reply Tim!

I can specify the same variable in File System Task Source. However my destination is dynamic and I want to use a variable. I'm not sure...

I think it runs fine with the SQL Agent job because the job might be using service account to run the process. Have you tried running the SSIS package using...

Thank you!

Great, its working. Thanks so much Mark!

Miller/Barry,

Thanks so much! Its working.

Great, Thanks Chuck. Its working.