Forum Replies Created
Viewing 15 posts - 6,196 through 6,210 (of 13,877 total)
-
RE: Must declare the scalar variable appears in SSMS and not in VS (SSDT)
Robert Frasca (12/15/2016)
That's actually the way it is in my code except for the insert and select statements which are one line. Of course, I chose the wrongtag...Sorry...
-
RE: Must declare the scalar variable appears in SSMS and not in VS (SSDT)
Here is the code again, this time with IFCode formatting (please do this in future, to aid your readers)
DECLARE @rowGUID [uniqueidentifier],@InfoXML [varbinary] (max)
,@InfoXMLPerf [varbinary] (max)
,@AppGuid [uniqueidentifier]
DECLARE @LogTable AS TABLE (
LogDatetime...
-
RE: SSIS Process only the "Latest" file based on name
Lowell (12/15/2016)
I've got a situation where csv files are superseded by another in a given month; they gather on an FTP site for collection at my convenience.they do follow...
-
RE: Solving an SSIS Error – Cannot convert between Unicode and non-Unicode
It would be interesting to know how performance varies between the two options (CAST in source and data conversion in package).
For those with separate servers running SSIS, doing the data...
-
RE: Desing of a table and Hirerarchy - IP's
wanttolearn1 (12/13/2016)
to be more clear this is an example of what i want to produce (the number in the square is the subnet selected)
What software are you going to use...
-
RE: How to get value based on position of special character string in a column
vikram_patro (12/14/2016)
I attached the sample data in excel to the original post, hope that helps.Also attaching here.
I mean, like this
SELECT *FROM
(
VALUES
...
-
RE: How to get value based on position of special character string in a column
vikram_patro (12/14/2016)
Hi John, thanks for the quick reply but I was not clear earlier. Can you check my post again now.Thank you, Vikram
Are you able to provide your sample data...
-
RE: Desing of a table and Hirerarchy - IP's
wanttolearn1 (12/13/2016)
Thanksi want the result to be in some hierarchy (this is after each ip "," followed by depth level
10.0.0.0,0
10.13.15.63,1
10.16.8.2,1
15.0.0.0,0
...
-
RE: Desing of a table and Hirerarchy - IP's
wanttolearn1 (12/13/2016)
want to build a table, which contains different ip and there sub-net.when i pull the table i want to get result in way i know who os the...
-
RE: Unable to map an environment variable with the sensitive property set to True
PSB (12/13/2016)
Not sure what I need to fix and where in environment variables. Can you please elaborate ?Change the 'Sensitive' property of either the environment variable or of the package...
-
RE: Unable to map an environment variable with the sensitive property set to True
PSB (12/13/2016)
Hi,I am getting the error below from the SSIS package scheduled from a SQL agent job . Locally the package works fine.
Description: Unable to map an environment...
-
RE: GROUP BY in SQL Server 2014
zouzou (12/13/2016)
Hello all,The same query with a group by clause I try to run on SQL Server 2005 and on SQl Server 2014 but it seems that every time i...
-
RE: SSMS for SQL 2016 cannot edit maintainance plan
sqlfriends (12/12/2016)
Thank you, will give a try.Also my other part of the questions, if SQL data tool not installed, but just installed SSMS, can I edit or create maintenance plan?
It...
-
RE: SSIS Execution Annonymous Login Error
mandavli (12/12/2016)
it's active directory userOK, yet a SQL Agent job which runs the package gives that error ... are you certain?
Viewing 15 posts - 6,196 through 6,210 (of 13,877 total)