Viewing 15 posts - 106 through 120 (of 130 total)
sqlzealot-81 (7/13/2011)
Can you just try to recompile the sp . Meanwhile we would be able to check the execution plan.
I don't think this is a stored proc (As I don't...
July 13, 2011 at 6:02 am
More info:
Doing a Bing search shows that many people had this error with SQL Server 2005 when there was SP differences.
The Test server (that it does work on)...
July 12, 2011 at 1:32 pm
Another piece of info: The error happens while in the Submitting Configuration Information step; this is on the Development server. On the Test server, it gets past this step...
July 12, 2011 at 1:15 pm
Is it a User DSN, a System DSN or a File DSN? I believe the first two (User and System) are stored in the Registry -- so the easiest...
July 12, 2011 at 8:37 am
Thank you; it does appear that the 'Database Tuning Advisor' is what my coworker was referring to. I'll take your advice regarding its recommendations.
Thanks,
Rob
July 12, 2011 at 6:38 am
sql_novice_2007 (7/6/2011)
July 6, 2011 at 1:48 pm
If I read the original question correctly, I think he wants the highest number per account/address (the first eight digits). Maybe something like:
CREATE TABLE #MyTempTbl_01 (WholeId varchar(10))
INSERT #MyTempTbl_01 (WholeId)...
July 5, 2011 at 9:31 am
chornung (7/1/2011)
There are hundreds of records in the db for each agency. However, some are...
July 1, 2011 at 1:03 pm
PaulB-TheOneAndOnly (7/1/2011)
If you need both the top 50 and the count() then you have to do both.
That's what I thought; I was just wondering if there was some behind the...
July 1, 2011 at 12:46 pm
chornung (7/1/2011)
SELECT AgencyName,...
July 1, 2011 at 12:07 pm
laddu4700 (7/1/2011)
Package execution results:
…
….
[Flat File Destination [61]] Error: Data conversion failed. The data conversion for column...
July 1, 2011 at 11:34 am
laddu4700 (7/1/2011)
rgtft (7/1/2011)
What happens when you change your data source's SELECT to put double quotes around that field?
SELECT '"' + [FreeTextColumn] + '"' AS QuotedFreeTextColumn
I am getting package validation error.
Package...
July 1, 2011 at 11:11 am
What happens when you change your data source's SELECT to put double quotes around that field?
SELECT '"' + [FreeTextColumn] + '"' AS QuotedFreeTextColumn
July 1, 2011 at 10:11 am
laddu4700 (7/1/2011)
There is a free text column in table, is this something issue with that column data?
My first guess would be to look for delimiter characters inside the free text...
July 1, 2011 at 9:12 am
Viewing 15 posts - 106 through 120 (of 130 total)