MSMQ

Does anyone know or have any idea what's the use of msmq or how can this apply in ssis.

Thanks

Find out what MQ is-

Message Queuing (MSMQ)
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/msmq/html/ff917e87-05d5-478f-9430-0f560675ece1.asp)

Find out about the MQ task you have in SSIS-

Message Queue Task
(http://msdn2.microsoft.com/en-us/library/ae1d8fad-6649-4e93-b589-14a32d07da33.aspx)

|||

Do you have a requirement to use MSMQ, or are you just curious about it? If you're just curious about it then google both terms and do some research.

If you have specific questions about either MSMQ or the MSMQ task in SSIS ask them here, and I will try my best to answer them for you.

|||

can you help me how am i going to use this the "MSMQ task in SSIS"? thanks

Sean Schade wrote:

Do you have a requirement to use MSMQ, or are you just curious about it? If you're just curious about it then google both terms and do some research.

If you have specific questions about either MSMQ or the MSMQ task in SSIS ask them here, and I will try my best to answer them for you.

|||

Can you help us and explain what you are trying to achieve? The task is there, documented, and does what it says on the tin. Do you want to send a message? Do you want to recieve a message?

Have you read any of the references or do you have any specific questions?

Do you know how to create a SSIS package?

Can you add a task to a package? (Hint - Drag and drop from the toolbox)

Now open the the task, and fill in the details required. What could be simpler?

How you use it in the context of a wider application or process is an impossible question on its own as we have no idea what you need to do!

|||

Hi All,

I am going to build an application that is transaction sensitive with asp.net, C# and SQL Server. There will be a folder which will have the text files and I am writing a windows service that picks up these text files and inserts them into SQL Server database. In case, if the SQL Server is down I should not lose any transactions and based on what I read I am thinking that MSMQ is the option wherein I can queue the transactions and insert them into the database once the SQL server is up and running.

Please suggest if this is correct approach or if there is any other alternatvie.

Thanks,

Thanvi

Msg 2714

Any idea why I get the following error:
Msg 2714, Level 16, State 1, Line 16
There is already an object named '#errlog' in the database.
when I run the following statement:
IF object_id('tempdb..#errlog') IS NOT NULL
DROP TABLE #errlog
IF @.@.VERSION LIKE '%9.00%'
CREATE TABLE #errlog
(
logdate datetime,
processinfo varchar(50),
logtext varchar(2000)
)
ELSE
CREATE TABLE #errlog
(
errorlog varchar(2000),
c2 int
)
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200604/1Yes...even though you have the logic contract, the
statement will be seen as two create table statements
attempting to create tables of the same name.
One option is to wrap each create table #errlog...etc
statement in an EXEC.
IF @.@.VERSION LIKE '%9.00%'
EXEC ('CREATE TABLE #errlog
(
logdate datetime,
processinfo varchar(50),
logtext varchar(2000)
)')
ELSE
EXEC('CREATE TABLE #errlog1
(
errorlog varchar(2000),
c2 int
)')
-Sue
On Mon, 24 Apr 2006 20:51:52 GMT, "cbrichards" <u3288@.uwe>
wrote:

>Any idea why I get the following error:
>Msg 2714, Level 16, State 1, Line 16
>There is already an object named '#errlog' in the database.
>when I run the following statement:
>IF object_id('tempdb..#errlog') IS NOT NULL
> DROP TABLE #errlog
>IF @.@.VERSION LIKE '%9.00%'
> CREATE TABLE #errlog
> (
> logdate datetime,
> processinfo varchar(50),
> logtext varchar(2000)
> )
>ELSE
> CREATE TABLE #errlog
> (
> errorlog varchar(2000),
> c2 int
> )|||Is that because it is a DDL statement that it nees to be wrapped as such?
Sue Hoegemeier wrote:[vbcol=seagreen]
>Yes...even though you have the logic contract, the
>statement will be seen as two create table statements
>attempting to create tables of the same name.
>One option is to wrap each create table #errlog...etc
>statement in an EXEC.
>IF @.@.VERSION LIKE '%9.00%'
> EXEC ('CREATE TABLE #errlog
> (
> logdate datetime,
> processinfo varchar(50),
> logtext varchar(2000)
> )')
>ELSE
> EXEC('CREATE TABLE #errlog1
> (
> errorlog varchar(2000),
> c2 int
> )')
>-Sue
>
>[quoted text clipped - 18 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200604/1|||In the original version you had, when parsing or compiling
the query the engine will see two distinct create table
statements trying to create a table of the same name.
If you wrap it in an exec, the engine will use deferred
resolution.
-Sue
On Mon, 24 Apr 2006 22:31:59 GMT, "cbrichards via
droptable.com" <u3288@.uwe> wrote:
[vbcol=seagreen]
>Is that because it is a DDL statement that it nees to be wrapped as such?
>Sue Hoegemeier wrote:|||Why does it see "two distinct create table statements" when it is within an
IF construct? Truly their are two create statements, but the IF is
conditional, correct?
Sue Hoegemeier wrote:[vbcol=seagreen]
>In the original version you had, when parsing or compiling
>the query the engine will see two distinct create table
>statements trying to create a table of the same name.
>If you wrap it in an exec, the engine will use deferred
>resolution.
>-Sue
>
>[quoted text clipped - 25 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200604/1|||On Wed, 26 Apr 2006 17:19:57 GMT, cbrichards via droptable.com wrote:

>Why does it see "two distinct create table statements" when it is within an
>IF construct? Truly their are two create statements, but the IF is
>conditional, correct?
Hi cbrichards,
At parse and compile time, the batch is scanned from top to bottom,
without checking conditional execution. This check sees two CREATE TABLE
statements and regards that as an error condition.
Hugo Kornelis, SQL Server MVP|||It doesn't know the path for the logic branch until run time
- not at parse or compile time. Consequently it will see two
different create table statements of the same name.
-Sue
On Wed, 26 Apr 2006 17:19:57 GMT, "cbrichards via
droptable.com" <u3288@.uwe> wrote:
[vbcol=seagreen]
>Why does it see "two distinct create table statements" when it is within an
>IF construct? Truly their are two create statements, but the IF is
>conditional, correct?
>Sue Hoegemeier wrote:

Msg 2714

Any idea why I get the following error:
Msg 2714, Level 16, State 1, Line 16
There is already an object named '#errlog' in the database.
when I run the following statement:
IF object_id('tempdb..#errlog') IS NOT NULL
DROP TABLE #errlog
IF @.@.VERSION LIKE '%9.00%'
CREATE TABLE #errlog
(
logdate datetime,
processinfo varchar(50),
logtext varchar(2000)
)
ELSE
CREATE TABLE #errlog
(
errorlog varchar(2000),
c2 int
)
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1Yes...even though you have the logic contract, the
statement will be seen as two create table statements
attempting to create tables of the same name.
One option is to wrap each create table #errlog...etc
statement in an EXEC.
IF @.@.VERSION LIKE '%9.00%'
EXEC ('CREATE TABLE #errlog
(
logdate datetime,
processinfo varchar(50),
logtext varchar(2000)
)')
ELSE
EXEC('CREATE TABLE #errlog1
(
errorlog varchar(2000),
c2 int
)')
-Sue
On Mon, 24 Apr 2006 20:51:52 GMT, "cbrichards" <u3288@.uwe>
wrote:
>Any idea why I get the following error:
>Msg 2714, Level 16, State 1, Line 16
>There is already an object named '#errlog' in the database.
>when I run the following statement:
>IF object_id('tempdb..#errlog') IS NOT NULL
> DROP TABLE #errlog
>IF @.@.VERSION LIKE '%9.00%'
> CREATE TABLE #errlog
> (
> logdate datetime,
> processinfo varchar(50),
> logtext varchar(2000)
> )
>ELSE
> CREATE TABLE #errlog
> (
> errorlog varchar(2000),
> c2 int
> )|||Is that because it is a DDL statement that it nees to be wrapped as such?
Sue Hoegemeier wrote:
>Yes...even though you have the logic contract, the
>statement will be seen as two create table statements
>attempting to create tables of the same name.
>One option is to wrap each create table #errlog...etc
>statement in an EXEC.
>IF @.@.VERSION LIKE '%9.00%'
> EXEC ('CREATE TABLE #errlog
> (
> logdate datetime,
> processinfo varchar(50),
> logtext varchar(2000)
> )')
>ELSE
> EXEC('CREATE TABLE #errlog1
> (
> errorlog varchar(2000),
> c2 int
> )')
>-Sue
>>Any idea why I get the following error:
>>Msg 2714, Level 16, State 1, Line 16
>[quoted text clipped - 18 lines]
>> c2 int
>> )
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1|||In the original version you had, when parsing or compiling
the query the engine will see two distinct create table
statements trying to create a table of the same name.
If you wrap it in an exec, the engine will use deferred
resolution.
-Sue
On Mon, 24 Apr 2006 22:31:59 GMT, "cbrichards via
SQLMonster.com" <u3288@.uwe> wrote:
>Is that because it is a DDL statement that it nees to be wrapped as such?
>Sue Hoegemeier wrote:
>>Yes...even though you have the logic contract, the
>>statement will be seen as two create table statements
>>attempting to create tables of the same name.
>>One option is to wrap each create table #errlog...etc
>>statement in an EXEC.
>>IF @.@.VERSION LIKE '%9.00%'
>> EXEC ('CREATE TABLE #errlog
>> (
>> logdate datetime,
>> processinfo varchar(50),
>> logtext varchar(2000)
>> )')
>>ELSE
>> EXEC('CREATE TABLE #errlog1
>> (
>> errorlog varchar(2000),
>> c2 int
>> )')
>>-Sue
>>Any idea why I get the following error:
>>Msg 2714, Level 16, State 1, Line 16
>>[quoted text clipped - 18 lines]
>> c2 int
>> )|||Why does it see "two distinct create table statements" when it is within an
IF construct? Truly their are two create statements, but the IF is
conditional, correct?
Sue Hoegemeier wrote:
>In the original version you had, when parsing or compiling
>the query the engine will see two distinct create table
>statements trying to create a table of the same name.
>If you wrap it in an exec, the engine will use deferred
>resolution.
>-Sue
>>Is that because it is a DDL statement that it nees to be wrapped as such?
>[quoted text clipped - 25 lines]
>> c2 int
>> )
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200604/1|||On Wed, 26 Apr 2006 17:19:57 GMT, cbrichards via SQLMonster.com wrote:
>Why does it see "two distinct create table statements" when it is within an
>IF construct? Truly their are two create statements, but the IF is
>conditional, correct?
Hi cbrichards,
At parse and compile time, the batch is scanned from top to bottom,
without checking conditional execution. This check sees two CREATE TABLE
statements and regards that as an error condition.
--
Hugo Kornelis, SQL Server MVP|||It doesn't know the path for the logic branch until run time
- not at parse or compile time. Consequently it will see two
different create table statements of the same name.
-Sue
On Wed, 26 Apr 2006 17:19:57 GMT, "cbrichards via
SQLMonster.com" <u3288@.uwe> wrote:
>Why does it see "two distinct create table statements" when it is within an
>IF construct? Truly their are two create statements, but the IF is
>conditional, correct?
>Sue Hoegemeier wrote:
>>In the original version you had, when parsing or compiling
>>the query the engine will see two distinct create table
>>statements trying to create a table of the same name.
>>If you wrap it in an exec, the engine will use deferred
>>resolution.
>>-Sue
>>Is that because it is a DDL statement that it nees to be wrapped as such?
>>[quoted text clipped - 25 lines]
>> c2 int
>> )

MSDTC Resource in the Cluster Group

Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?
It's more a matter of usage and availability. If you use it a lot, even
though its small, it takes it toll on the disk. You would never want MSDTC
to take cycles away from what the quorum is trying to use. As for
availability, what happens if you have a resource failure? By default, the
group is afftected. Putting more things in ANY group, affects the group as a
whole. For the Highest Availability, keep everything separate.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:E91F75E1-1006-4062-8BC7-35D94FD3E77F@.microsoft.com...
> Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
> if
> the MSDTC has its own IP Address and Network Name?
> In my planned multiple instance sql cluster, I can see giving up a
> physical
> disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
> doesn't use tons on disk space, can I put it in the same group as the
> defualt
> instance of SQL, again as long has it has its own IP Address and Network
> Name?

MSDTC in Cluster Group

Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?
The original MS KB posts recommended using the Cluster Group resource;
however, we've found out that it does not work and an instance of SQL Server
can not bind to it unless it's on the same node.
You can put it in the SQL Server Group resource, but it won't work once you
go multi-instanced. At that point, MS recommends that you create a seperate
shared disk resource with its own IP and Network Name resources and cluster
MS DTC as a seperate group. Looks like the coders didn't think through the
implications of the Quorum and coded against it. The SQL Server
developement group did not realize this.
Sincerely,
Anthony Thomas

"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:922FDA87-A645-43C7-8442-BAD97525A3F1@.microsoft.com...
Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the
defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?

MSDTC in Cluster Group

Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?The original MS KB posts recommended using the Cluster Group resource;
however, we've found out that it does not work and an instance of SQL Server
can not bind to it unless it's on the same node.
You can put it in the SQL Server Group resource, but it won't work once you
go multi-instanced. At that point, MS recommends that you create a seperate
shared disk resource with its own IP and Network Name resources and cluster
MS DTC as a seperate group. Looks like the coders didn't think through the
implications of the Quorum and coded against it. The SQL Server
developement group did not realize this.
Sincerely,
Anthony Thomas
"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:922FDA87-A645-43C7-8442-BAD97525A3F1@.microsoft.com...
Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the
defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?