Viewing 9 posts - 61 through 69 (of 69 total)
Helmut,
Daniel Read has a solution for you here: http://www.developerdotstar.com/community/node/512
This should get you going in the right direction.
Dan
August 27, 2007 at 1:44 pm
It's always a challenge to troubleshoot from a distance, but here goes...
Try checking the permissions on ServerB to make sure the Agent...
August 23, 2007 at 2:22 pm
Here's one I use to create a file name out of a DATEPART extraction:
"\\\\server\\Shared\\dir\\IS\\BI\\LastOrderFiles\\" + "LastOrder" + (DT_WSTR, 2) (DATEPART( "mi", GETDATE() ) ) + ".xml"
The "DATEPART" returns the minute...
August 23, 2007 at 7:52 am
I agree wirh Frank - you are trying to represent multiple data grains in one table.
The Quantity column is at the grain of the line, but your GrossSaleAmount is at...
August 23, 2007 at 7:34 am
You can find the correct columns by going to the advanced editor in your data flow tasks.
August 23, 2007 at 7:14 am
Brian,
Is this merely a single task control flow package, or is there more involved? The error you posted looks like the error from the job, rather than an SSIS execution...
August 16, 2007 at 2:21 pm
When you run from within BIDS, you are running the package with your account. The job uses (by default) the SQL Agent Service Account. Make sure the service account has...
August 16, 2007 at 2:09 pm
Frank,
A couple things you can check:
August 16, 2007 at 1:59 pm
Here's an article about that very thing...
http://edition.cnn.com/2007/US/03/08/N.C.beer.tossing.ap/index.html
March 23, 2007 at 6:17 am
Viewing 9 posts - 61 through 69 (of 69 total)