Viewing 15 posts - 661 through 675 (of 13,463 total)
COPY or MOVE? there's a difference!
copy duplicates the data, so you have to script all the objects out, change the schema in that script , and create the objects...
January 27, 2017 at 6:25 am
So I created a new schema. Now I need to move the stored...
January 26, 2017 at 2:37 pm
January 24, 2017 at 10:38 am
i believe the specific error/issue is here:@command1='INSERT #Sou
it has to be marked with...
January 24, 2017 at 10:31 am
is your file name you are writing to dynamic? Did you modify your flat file destination to have an expression that points to what the dynamic file name should be?
January 23, 2017 at 2:28 pm
you said I opened a new query window and ran this:
select convert(nvarchar(64),context_info())
the context_info is session specific, similar to a temp table.
so if i call a...
January 23, 2017 at 1:37 pm
duplicate post.
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Latest Posts" link shows us everything.
continue...
January 23, 2017 at 8:21 am
the classic way would be to use GROUP BY HAVING count > 1
SELECT
Col1,Col2,Col3,Col10Or12
FROM
YourTable
GROUP BY Col1,Col2,Col3C,Col10Or12
HAVING COUNT(*) >...
January 20, 2017 at 1:04 pm
if you can modify the stored procedure, you could populate the VARBINARY(128) CONTEXT_INFO property.
that value is session based, i believe, so if the application calls a proc, and...
January 20, 2017 at 7:56 am
how to monitor DBmail, I mean in terms of audit if the...
January 19, 2017 at 2:43 pm
if the referenced table has a specific column name (in the example [StatisticsName]), this will find all objects that are referencing the object(ie table) in question.
...
January 19, 2017 at 10:20 am
using row number is how i would find the dupes.
the query i'm using here can be switced to a delete by simply swapping the commenting the --DELETE and commenting...
January 18, 2017 at 11:56 am
you can end up getting the empty "toolbox" from visual studio, which IS NOT THE SAME as the ssis toolbox.
there's always a shortcut for the SSIS toolbox and SSIS variables...
January 17, 2017 at 1:26 pm
Additionally, shouldn't it say that it wrote 0 rows if it could not write to the file?
I think the Flat File Connection Manager will create a...
January 17, 2017 at 8:32 am
you said it occurs when the package is run on the server, by the proxy or service account, right? or by another, specific user.....
check the permissions on the...
January 17, 2017 at 7:18 am
Viewing 15 posts - 661 through 675 (of 13,463 total)