Viewing 15 posts - 16 through 30 (of 107 total)
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?
July 24, 2015 at 12:53 am
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...
July 24, 2015 at 12:52 am
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...
July 24, 2015 at 12:49 am
Do full table load otherwise use an incremental load. You can use Merge in SQL to implement incremental load.
July 22, 2015 at 2:45 am
In package deployment model you can use config table or config file instead.
July 22, 2015 at 12:17 am
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. ...
July 16, 2015 at 9:51 pm
Try converting this column in SQL query instead of SSIS.
Also, it would be of great help if you can elaborate your query properly.
July 15, 2015 at 10:15 pm
This is interesting.
Have you checked your configuration values? Is it pointing to the same sample file you have used in your development environment.
July 15, 2015 at 10:09 pm
I Concur,
SSIS will be easiest and re-usable approach.
Good Luck.
July 15, 2015 at 10:05 pm
This is because these are query-driven parameters. You need to create data driven subscription in this case.
June 11, 2015 at 3:10 am
Use For XML.
June 11, 2015 at 3:08 am
The vendor will provide you the private key file.
Cheers.
A
June 8, 2015 at 10:38 pm
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...
June 8, 2015 at 2:02 am
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...
June 5, 2015 at 3:44 am
Viewing 15 posts - 16 through 30 (of 107 total)