Viewing 15 posts - 6,931 through 6,945 (of 11,678 total)
So you are using package configurations to store the sensitive information inside a SQL Server config table?
June 11, 2012 at 12:18 am
It's a wizard. By defination a graphical user interface designed to guide a user through a certain process.
Why would you ever want to call that from a trigger?
June 11, 2012 at 12:16 am
I don't think you can.
That would require the SELECT statement to return results skipping certain rows, which is practically impossible without an ORDER BY clause and hence virtually unfeasible to...
June 11, 2012 at 12:12 am
Haining (6/10/2012)
You should also notice that in SQL 2012, it is possible for one to convert legacy deployment model to project deployment model.
Yes, and that's probably where your confusion comes...
June 11, 2012 at 12:08 am
The behaviour should not be dependent on the OS.
What is this "SSIS new project for flat file conversion "?
There are only two ways of developing SSIS projects:
* Project Deployment Model:...
June 10, 2012 at 11:13 pm
Haining (6/9/2012)
So, if...
June 10, 2012 at 1:48 pm
Jan.Sundbye (6/8/2012)
opc.three (6/7/2012)
Koen Verbeeck (6/7/2012)
opc.three (6/6/2012)
The marketing material says you can, but I have not tried it so could not say how accurate the claims are.
I don't think you can...
June 8, 2012 at 5:46 am
If you do a preview in the flat file source, does the data look OK?
June 8, 2012 at 5:23 am
Stupeo (6/8/2012)
Why's that? Do they have known issues :unsure:?
I'm not sure about the current generation, but I had issues with mine as did a coworker.
My MBP was about 3.5 years...
June 8, 2012 at 3:07 am
Stupeo (6/8/2012)
Hopefully this laptop should be a keeper and last me until the warranty runs out (2015!).
Be prepared to change your battery after a while 😀
June 8, 2012 at 2:04 am
Stupeo (6/8/2012)
June 8, 2012 at 2:03 am
Why don't you just assign a sequencenumber to the same incident references, instead of this overly complicated datetime function?
If you would get rid of the function and the subquery, tune...
June 8, 2012 at 1:44 am
Stewart, this discussion is continued in another topic:
http://www.sqlservercentral.com/Forums/Topic1312885-391-1.aspx
June 8, 2012 at 1:41 am
Do you have spaces at the beginning of the line?
You must have done something wrong in the configuration, because when you define the lengths, you do this on the preview...
June 8, 2012 at 1:29 am
Viewing 15 posts - 6,931 through 6,945 (of 11,678 total)