Viewing 15 posts - 4,231 through 4,245 (of 11,676 total)
Any idea on what kind of object it fails?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 17, 2013 at 1:33 pm
hoolash (11/17/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 17, 2013 at 1:24 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
November 17, 2013 at 1:14 pm
This article explains it pretty much:
Introducing the Foreach Loop Container[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 17, 2013 at 1:07 pm
blasto_max (11/17/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 17, 2013 at 12:49 pm
Giving the service account permissions, would mean that all the jobs executed by that service accounts have permission to everything.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 15, 2013 at 7:22 am
Found the issue. Found a log file in \AppData\Local\Temp, called SqlSetup.log
Most important line was:
Error: Cannot load .Net security policy file 0x80004005
A quick google search told me to reset the .NET...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 15, 2013 at 5:20 am
christian.terhart (11/15/2013)
So the key question is:if the package and the flatfile are on the same server are there any disadvantages to use the network-path
Kind Regards
Christian
Not that I know of.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 15, 2013 at 1:18 am
I said a "decent" text editor.
Try notepad++ and configure it to show all symbols.
Maybe you are missing some row delimiters or something like that.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 15, 2013 at 12:31 am
Seems there are some issues with your file.
unexpected end of file
data conversion error
truncation occurred
Those don't sound good. Open the CSV file with a decent text editor and look for anomalies.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 15, 2013 at 12:10 am
Very interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 14, 2013 at 11:59 pm
It seems the test you did was twice the same folder, but with different notations. The folder was each time on the local server.
If you move the SSIS package to...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 14, 2013 at 2:00 pm
Did you read the MSDN article I linked to?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 14, 2013 at 5:12 am
Yes.
Upgrade to a Different Edition of SQL Server 2012
You should worry more about migrating SQL 2000 to SQL 2012 instead of the editions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 14, 2013 at 3:46 am
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 14, 2013 at 12:29 am
Viewing 15 posts - 4,231 through 4,245 (of 11,676 total)