Viewing 15 posts - 9,826 through 9,840 (of 11,678 total)
Jamie Thomson (3/10/2011)
This one may be particularly useful: Visual Studio 2010 SQL Server Database Projects
Thanks for the references!
March 10, 2011 at 6:00 am
You can try the following:
-----> CONVERT(BIT,1) for True
-----> CONVERT(BIT,0) for False
This will return a boolean value instead of a tinyint.
March 10, 2011 at 5:47 am
What should be done with a topic like this?
http://www.sqlservercentral.com/Forums/Topic1076147-147-1.aspx
It isn't spam, it is about business intelligence, but it is promotion for a company. Shouldn't they pay for advertising to Redgate?
March 10, 2011 at 5:41 am
Brandie Tarvin (3/10/2011)
March 10, 2011 at 5:09 am
Andrew Williams (3/10/2011)
loop through the tables doing:
1. Script task to create dynamic sql to create the table if it doesn't exist on destination.
2. Run sql against...
March 10, 2011 at 3:53 am
krishnaroopa (3/10/2011)
Basically I try to insert data from excel to sql table. Along with the data,...
March 10, 2011 at 3:46 am
So the task turns red and there is no message in the output window that starts with "Error:"?
Did you configure anything for a resultset?
Are there properties set for the task...
March 10, 2011 at 2:51 am
Nice question. And thanks Chris for posting the reference.
March 10, 2011 at 2:24 am
smac (3/9/2011)
I just think I have tried so many things and changed by package so much can...
March 10, 2011 at 12:01 am
Khades (3/9/2011)
As always, thank you Koen.
No problem, glad to help.
March 9, 2011 at 11:55 pm
Koen Verbeeck (3/9/2011)
Either run the package in 32-bit mode (if there is a 32-bit Oracle OLE DB provider), or install the 64-bit provider (search Microsoft website for Attunity).
Sometimes the answer...
March 9, 2011 at 11:54 pm
nheller (3/9/2011)
ignore the "" qualifier on import.use derived columns to strip out the double quotes using the replace function.
What if there is a string with a comma in it? Won't...
March 9, 2011 at 11:52 pm
How did you configure the Excel connection manager? Are you sure you selected 97-2003 file format there?
The provider for .xls is the JET OLE DB provider, while the provider for...
March 9, 2011 at 11:51 pm
Allright, first of all, as Preethi S Raj mentioned, are you developing on a 32-bit machine or a 64-bit machine?
Are there any other errors?
Is it possible to set a breakpoint...
March 9, 2011 at 11:49 pm
I shall refer you to the following topic that discusses the same problem, but it unfortunately doesn't offer any direct solutions:
http://www.sqlservercentral.com/Forums/Topic638571-148-1.aspx
March 9, 2011 at 12:48 pm
Viewing 15 posts - 9,826 through 9,840 (of 11,678 total)