Viewing 15 posts - 10,171 through 10,185 (of 11,678 total)
prashantjain07 (2/10/2011)
now its working ....thanx dude... 😀
No problem, glad to help.
February 10, 2011 at 1:15 am
Allright, I've tried it in a test package and I could get it to work.
Do the following:
1. Seperate the create and insert step from the select step. Place the creation...
February 10, 2011 at 12:38 am
Let's start with the basics:
can you somehow verify that the used credential has actually access to the other server?
February 10, 2011 at 12:11 am
quasar_phoenicis (2/9/2011)
so i have a query that selects a min date in my sql 2008 database that resulted to 1750-01-01 00:00:00.0000000 (datetime2 data type). This query is being executed in...
February 10, 2011 at 12:02 am
Phil Parkin (2/9/2011)
Look harder at the word 'this' 🙂
All that trouble to make a nicely formatted hyperlink 😀
February 9, 2011 at 11:56 pm
Can you try setting the ForceExecutionResult property of the Execute SQL Task to Succeed?
February 9, 2011 at 11:53 pm
Nice question, thanks.
What is it with Microsoft and giving names to products?
February 9, 2011 at 11:46 pm
IF EXISTS (SELECT TOP 1 *
FROM Tempdb.dbo.sysobjects (nolock)
WHERE name LIKE ''##TUser%'')
DROP TABLE ##TUser
Is there a reason why there are two times single quotes around TUser% in the LIKE clause?
If...
February 9, 2011 at 11:42 pm
nadabadan (2/9/2011)
bla bla bla
Ah. Glad you're back. This discussion is so much less entertaining without you.
February 9, 2011 at 11:32 pm
Why are you using EXEC to execute your statements. You don't have dynamic SQL, so I don't see the point.
Furthermore, it is possible that the statement within the EXEC is...
February 9, 2011 at 11:33 am
Is the Integration Services service running on the same server as the destination table?
February 9, 2011 at 11:21 am
Great! Glad that if finally worked out.
Thanks for posting back.
February 9, 2011 at 11:19 am
Brandie Tarvin (2/9/2011)
Dave Ballantyne (2/9/2011)
Handed my notice in today , i can already feel the freedom 🙂Actually, that's just the wind blowing up your kilt. @=)
For all those kilt wearers...
February 9, 2011 at 11:15 am
pmm.sudarsan:
It is much easier to just set the DelayValidation property of the dataflow to TRUE.
This way, validation will wait until the dataflow starts running. By that time, the table is...
February 9, 2011 at 5:06 am
What happens when you try to start the service in SQL Server Configuration Manager?
February 9, 2011 at 3:55 am
Viewing 15 posts - 10,171 through 10,185 (of 11,678 total)