Viewing 15 posts - 5,146 through 5,160 (of 11,676 total)
rswilliams 94513 (8/14/2013)
Setting the project property Run64BitRuntime to False fixed the problem.Thanks,
Randy
Great, glad that you got it solved.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 1:28 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 11:04 am
SQLSteve (8/14/2013)
s_osborne2 (8/14/2013)
I avoid that wizard where possible if i'm honest. Glad you got the data inserted! 🙂I will now be avoiding the wizard too!
Cheers for the help
I only...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 10:56 am
SQLSteve (8/14/2013)
I wish I knew why the export wizard didn't work...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 10:56 am
If you have only installed the 32-bit client on the new server, try setting Run64BitRuntime on the project to false.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 10:53 am
wolfkillj (8/14/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 10:51 am
Are you trying to put empty values (=NULL) into a non-nullable column?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 7:57 am
Grant Fritchey (8/14/2013)
I can just hear what you say now.ha!
THAT'S FINE BY ME! 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 7:38 am
ChrisM@Work (8/14/2013)
... Not bad for a European.
I shall take this as a compliment! 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 7:25 am
Save the result of the wizard as a SSIS package and edit it in Visual Studio.
Change the data type to string instead of integer.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 7:24 am
Erland Sommarskog (8/14/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 6:40 am
And this post marks my 10,000th one on SSC! 😎 😎 :w00t: (and some of them were actually useful!)
Now that I'm one of the big boyz and Grant can finally...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 6:29 am
A lot of functionality of SSRS is ignored when exported to CSV.
How did you implement the switch between the two tablixes? The interactivity section in the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 6:22 am
Can you explain in more detail how you exactly pass the parameters to the stored procedure?
Screenshots might be nice.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 6:18 am
You'd need to use dynamic SQL for this. You can query the INFORMATION_SCHEMA.columns view to find out which columns a table has.
Using this info, you can construct a SQL...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 14, 2013 at 6:17 am
Viewing 15 posts - 5,146 through 5,160 (of 11,676 total)