What is the error message you are getting? also, why this task is failing?

Does the excel file is having any invalid records or something?

Ditto, you should check what the timeout period is actually set to.

Also, try connecting your source server and see if it is getting connected. Also, try executing your source...

It will not pick this config file and execute the package as per default values.

I would suggest use an environment variable on your server and provide configuration path there.

Otherwise, you...

Do full table load otherwise use an incremental load. You can use Merge in SQL to implement incremental load.

In package deployment model you can use config table or config file instead.

Yes, you can achieve this using SSIS.

Anamika (7/16/2015)

it started working when i connect with another machine which is having 2008. Not sure what was the problem with the previous machine which was having 2012. ...

Try converting this column in SQL query instead of SSIS.

Also, it would be of great help if you can elaborate your query properly.

This is interesting.

Have you checked your configuration values? Is it pointing to the same sample file you have used in your development environment.

I Concur,

SSIS will be easiest and re-usable approach.

Good Luck.

This is because these are query-driven parameters. You need to create data driven subscription in this case.

Use For XML.

The vendor will provide you the private key file.

Cheers.

A

1. I will be needing a Private Key file. My guess is vendor will provide it, am I right?

: Yes, you will need a private key file.

2. Vendor will provide...

That would be table definition.

I want something like we've a table - A.

It is used in SP - usp1

I want ann the further SP's/Objects which use this usp1 as well...