Viewing 15 posts - 12,601 through 12,615 (of 13,849 total)
Eek. Stop all activity on your PC and find an undelete app from somewhere, after first checking that the DTSX file is not magically in your Recycle bin.
You should also...
July 22, 2009 at 8:04 am
I am afraid I have no idea what could be happening, it all sounds very straightforward.
Does it always process exactly the same number of records? If yes, try putting an...
July 22, 2009 at 4:50 am
Thank you Allen - I was looking particularly healthy and radiant the day that one was taken :w00t:
When you modify a package in BIDS, you are probably updating a version...
July 22, 2009 at 4:27 am
While it may well be your company's policy to do this, it is not mandatory.
It is perfectly possible to create a SQL Agent job to run a package which exists...
July 22, 2009 at 4:04 am
phumlo1 (7/22/2009)
I am using an OLE DB Source in an SSIS package I inject sql script below to retrieve data from datasource. The source has 700 000 records but...
July 22, 2009 at 3:54 am
In an Execute SQL task, if you want to build a dynamic piece of SQL that includes variables, use the 'Expressions' area to override the SQLStatementSource property & this should...
July 22, 2009 at 3:42 am
There is perhaps a more elegant way of achieving what you want - check out "Creating Package Configurations" in BOL.
You could have a variable called (say) LoadDate which is assigned...
July 22, 2009 at 1:34 am
What does the ActiveX task do? Does it fail at a certain line, or does the whole task fail? Does it fail only when executed by the SQL Agent service?
July 21, 2009 at 10:38 am
Strange. You could try removing the variable from the Read/Write section and instead use the VariableDispenser method to retrieve/set the variable.
July 21, 2009 at 10:05 am
Running the restore from Server A would work fine, I believe. Server B would still be the one doing all the work: Server B is just issuing the control commands.
July 21, 2009 at 4:42 am
Why does the Server A task need to wait for the Server B task - is there some dependence there that you have not mentioned? What happens if the Server...
July 21, 2009 at 4:10 am
1) Create a Double variable to hold the result of executing the max sal query
2) Create a String variable to hold your variable SQL.
3) Run an Execute SQL task to...
July 20, 2009 at 2:28 am
So N is a Name record, A an Address record, etc?
.. the records length is fixed for certain records only, ...
Please explain what you mean by this and give...
July 17, 2009 at 10:49 pm
It's always a pleasure helping someone who's enthusiastic and eager to learn.
No rep points here - just hoping that good SQL karma will come back to me when I get...
July 17, 2009 at 7:29 am
Viewing 15 posts - 12,601 through 12,615 (of 13,849 total)