Viewing 13 posts - 1 through 13 (of 13 total)
I have the developer looking into recreating his profile.
Thanks for your help.
March 15, 2011 at 10:20 am
If you look in the Error window you can probably get more info. View, Error List
March 9, 2011 at 9:50 am
I would try the ForceExecutionResult property of File System Task
March 9, 2011 at 8:14 am
Here is how I do it in one of my SSIS packages.
1) Fig 1 - Delete the exisiting excel file
2) Fig 1 - Copy an empty Excel template into place...
March 8, 2011 at 1:35 pm
You can use the File System task to drop the Excel File.
March 8, 2011 at 12:53 pm
Little unsure what you're doing... drop a SQL table?
March 8, 2011 at 12:34 pm
You need to use the Data Conversion object to convert.
March 8, 2011 at 12:02 pm
Is the source data in an Access or SQL Server table?
March 8, 2011 at 11:35 am
In SQL Server 2005 we use a File System Task to creat the excel file, then an OLE DB datasource to feed the results of our query to an Excel...
March 8, 2011 at 9:53 am
This is what fixed the issue.
Posted by SQL-Pro in the Microsoft Forums.
"I would recommend aliasing your tables in the FROM clause and trying again
QUERY
UPDATE
A
SET
A.[Group] = B.[GROUP]
FROM
[X1ghqw00688].AP.DSDNDSD.REPORT_DATA_STAGING A
LEFT OUTER...
February 8, 2008 at 11:22 am
You're right, I started it at 7:00 PM last night and it's still running at 8:00 AM. (ran the update on all User Databases) It looks like it worked. ...
January 29, 2008 at 6:10 am
I'm going to give that a try tonight.
Thanks
January 28, 2008 at 1:12 pm
Viewing 13 posts - 1 through 13 (of 13 total)