Viewing 15 posts - 31 through 45 (of 60 total)
XML Config is always better as when u r deploying ur packages u can edit the values and deploy it
August 8, 2008 at 9:51 am
If no other way to skip then you should use script component as source
August 1, 2008 at 1:31 pm
I think using SCD component will also do the job.
try it out if you don't get it jus shoot out an email to me. @ emailsv@gmail.com
Priya: Just trying to...
August 1, 2008 at 1:22 pm
Well as far as my understanding goes using ssis will always help us b'coz ssis uses some of the resources which are not allocated to sql server 2005 and finally...
August 1, 2008 at 1:15 pm
It is always better if we build and install using the deployment utility but even the way u did also works
so not a problem.
July 24, 2008 at 8:24 pm
I assume that if the user is incoming record he is active otherwise he is inactive
well then in the flow add a derived column transformation and update it in...
July 24, 2008 at 8:22 pm
Using Sql to do the job will try to commit all the rows at a single so it'll block the server for a few minutes and if there are...
July 24, 2008 at 8:17 pm
you can skip the header row that shouldn't be a problem but skipping a last row is difficult
probably you can try to delete the footer using the script task...
July 24, 2008 at 8:13 pm
Can you post the table structures creation script (please include the current indexes creation script also)
As i've observed there are too many joins
I would suggest why not try breaking up...
July 18, 2008 at 6:35 am
Use Transaction Isolation Levels
If that doesn't work then seperate them into two seperate tasks
July 18, 2008 at 6:26 am
In execute Sql Task options
Set the followng options
Result Set: Single Row
In the parameter mapping tab
map the result set to a variable
The variable will be assigned with the number...
July 18, 2008 at 6:00 am
try this
(DT_DATE)(SUBSTRING(DT,5,2) + "-" + SUBSTRING(DT,7,2) + "-" + SUBSTRING(DT,1,4))
it worked for me
July 18, 2008 at 5:46 am
As long as all the excel files have the same structure these files can be imported using a for each loop. If not it is not possible.
So please check the...
July 18, 2008 at 5:44 am
Rightclick on the database..Select option to detach the database..
move the file to D Drive
Attach it back
July 18, 2008 at 5:42 am
Viewing 15 posts - 31 through 45 (of 60 total)