Viewing 15 posts - 8,746 through 8,760 (of 13,876 total)
Guitar_player (1/22/2015)
u mean to say that , dont delete the project in the SSIS DB catalog and just deploy the .ispac on the same folder in the SSISDB catalog ?
Exactly....
January 22, 2015 at 4:25 am
I do suggest, however, that you do this 'redeployment' by right-clicking on the 'Projects' node in your SSISDB catalog and selecting Deploy.
January 22, 2015 at 4:24 am
Deploying projects does not affect environments.
January 22, 2015 at 4:21 am
Guitar_player (1/22/2015)
I need info on the Deployment side..
I have built my package and and deployed the package to the SSISDB Catalog..
My project is something...
January 22, 2015 at 3:54 am
susmitha117 (1/21/2015)
I have a flat file which needs to be imported to SQL Database. My flat file contains Quotes as header delimiter. How do i remove that from header...
January 21, 2015 at 11:15 am
RonKyle (1/21/2015)
... and ID is not? What is it then?
'Id' is an abbreviation of a single word and is therefore valid, at least in standard written English.
When abbreviating 'Company', would...
January 21, 2015 at 7:48 am
Koen Verbeeck (1/21/2015)
Phil Parkin (1/21/2015)
RonKyle (1/21/2015)
I use ID. It's an abbreviation that otherwise doesn't form a word.'Id' is an abbreviation of a single word ...
As I pointed out earlier,...
January 21, 2015 at 7:38 am
RonKyle (1/21/2015)
I use ID. It's an abbreviation that otherwise doesn't form a word.
... and ID is not? What is it then?
'Id' is an abbreviation of a single word and...
January 21, 2015 at 7:27 am
Ian_McCann (1/21/2015)
openning the script in notepad++ and saving it as utf8 encoded and then reading it back with -Encoded UFT8 did work,
( there is always a but)
but
It took...
January 21, 2015 at 5:18 am
Out of interest, did you also try saving the input file with UTF-8 as suggested in the link?
January 21, 2015 at 4:50 am
Well, that narrowed the problem down well.
I think that the solution may be found in this article.
January 21, 2015 at 3:07 am
Nice article Andy. I have recently written a stored proc which looks very like yours.
The differences:
1) It lives in a separate library-type database (I want it clean and fully source-controlled)
2)...
January 21, 2015 at 2:57 am
I presume that you've checked that the T-SQL script works fine if you run it in SSMS? (Works fine on my system, so I am guessing yes.)
You could perhaps try...
January 21, 2015 at 2:12 am
brad.mccollum (1/20/2015)
I have a bunch of earlier-versioned SQL Server stuff still on my laptop and I'd like...
January 21, 2015 at 12:43 am
JoshDBGuy (1/20/2015)
Koen Verbeeck (1/20/2015)
JoshDBGuy (1/20/2015)
That's going to be a nightmare, I'd prefer to not do that.I'm not sure why a SQL Server instance would be a nightmare.
It's not a nightmare,...
January 20, 2015 at 12:00 pm
Viewing 15 posts - 8,746 through 8,760 (of 13,876 total)