Viewing 15 posts - 6,811 through 6,825 (of 11,678 total)
Why don't you try it out and see what happens?
The BDD component will help you to create multiple streams. Just deselect "table lock" in the OLE DB Destination with Fast...
June 26, 2012 at 2:22 am
Setting the Protection Level of Packages
It basically defines the way sensitive data is stored in the packages.
June 26, 2012 at 2:11 am
There seems to be some sort of validation error on one of the connections.
Is this the only message that you get? Can you post everything from the output window?
Do you...
June 25, 2012 at 11:36 pm
Try this:
(StoreID == 4) ? 10 : ((StoreID == 10) ? 4 :StoreID)
June 25, 2012 at 11:34 pm
It depends 🙂
Parallellism can give locking in your destination table if you are using a lot of indexes, but in such a large table you'd better drop the indexes before...
June 25, 2012 at 11:28 pm
Chances are high Lynn is right.
Either change the SQL Server Agent account on the DEV box to a domain account, or use a proxy.
Creating SQL Server Agent Proxies
I would go...
June 25, 2012 at 11:24 pm
Haven't used NULLIF before, so I learned something.
Small error: the select statement selects 4 columns, the answers have only 3.
June 25, 2012 at 11:20 pm
It seems that there's something wrong with your design.
You say subcategory can be part of multiple categories.
However, in your product table you have a FK to subcategory and a FK...
June 25, 2012 at 7:17 am
Strange answer by a MS employee:
Whether to support this kind of feature depends on your client display tool, PivotTable support this kind of feature, but Excel workbook does not have...
June 25, 2012 at 3:06 am
Got it wrong for all the reasons mentioned above.
Better luck tomorrow 🙂
June 25, 2012 at 2:53 am
ard5karthick (6/23/2012)
Hi Koen,We are using Package Configuration to store the details in the Configuration table...
Thanks,
Karthick.
That doesn't answer my question.
You have a connection manager pointing to the SQL Server database where...
June 25, 2012 at 12:19 am
mamatha17.r (6/22/2012)
I dont have idea on partioining plese let me know example how to write it
If you put some effort in it, you can find tons of information on the...
June 22, 2012 at 5:11 am
Hugo, thanks for the very lengthy and detailed explanation. I already figured out how it worked, but I found the original explanation "there isn't a WHERE clause" a bit lacking....
June 22, 2012 at 3:44 am
My guess is that you have duplicate rows in your source.
The first row inserts fine but at the second row you get the unique key violation error.
When you run the...
June 22, 2012 at 1:48 am
Please do not crosspost. It fragments replies and wastes peoples time.
Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1319065-391-1.aspx
June 22, 2012 at 12:57 am
Viewing 15 posts - 6,811 through 6,825 (of 11,678 total)