Showing posts with label connected. Show all posts
Showing posts with label connected. Show all posts

Wednesday, March 7, 2012

closing pipelinebuffer

Is there a way to signal to the PipelineBuffer during ProcessInput that no more rows are necessary?
Say I have a component's output connected to a custom destination component... in the destination component's properties, I can set the number of rows I want to consume. (The first 50 rows for example.) If I do it this way, the source component continues delivering rows - I can set my destination to ignore all rows after 50, but would like a way to tell the component above it "no more!"
Is this possible?
Steve
I am not sure what effect it would have on the upstream component, probably none, but to signal you are adding now more rows in ProcessInput you would normally use buffer.SetEndOfRowSet()|||Tried this... Can't use buffer.SetEndOfRowSet() on an input buffer, it throws an exception.
Also tried using buffer.Discard() but it seems to not have any effect on stopping the rows from continuing into the component.
Steve|||Ahh.. I was looking at an asynch component, and have the output buffers being used in ProcessInput!

I don't think this can be done, and not sure that it is a good idea even if you could. It would be like cancelling the package, mid-flow.|||No, you can not signal upstream components that you are done processing. You would have to do this at the source.

Thanks,
Matt|||Why not put in an extra transform component that only provides a certain number of rows. Like this: http://blogs.conchango.com/jamiethomson/archive/2005/07/27/1877.aspx

-Jamie|||Actually, that's exactly what I'm doing. But what happens is that say I just want 10 rows, and the input has 1,000,000 rows... the input will continue sending all 1,000,000 rows, even though they're being ignored. It would be nice to have something that tells the upstream component, "Hey, I don't need you anymore, don't send anything else, report success!"|||

Steven Pasetti wrote:

Actually, that's exactly what I'm doing. But what happens is that say I just want 10 rows, and the input has 1,000,000 rows... the input will continue sending all 1,000,000 rows, even though they're being ignored. It would be nice to have something that tells the upstream component, "Hey, I don't need you anymore, don't send anything else, report success!"

This will be helpful for debugging too... I can debug with only 10 rows and if everything is fine, I can run the 1,000,000 rows later.

Sunday, February 12, 2012

Client can't be connected.

Hi,
I want to connect my win-XP client with win-server-2003 SQL Server.
I had done following task-
- I had installed SQL-2000 (Ent. Edition) on Win-Server 2003. And it is
successfully installed.
- In Win-S-2003 with the help of Active Directory I created domain and
created user on it.
- Client computer (Win-XP Prof.) configured with domain system. and I can
successfully login on that computer as a administrator.
- On client computer installed Sql-2000 (Ent. Edition) client tool.
- In Client Network Utility Configured my SQL Server
- In Enterprise Manager I done new registration with following configuration
-- Connect using = window authontication
-- Here I found following error : SQL Server does not exist or
access denied Connection Open(Connect())
Please help me to connect my client.
Hardik.
Hi
Can you connect to SQL Server, though EM, from the SQL Server console?
If not, is SQL Server running?
Can the client ping the SQL Server server?
Regards
Mike
"Hardik Shah" wrote:

> Hi,
> I want to connect my win-XP client with win-server-2003 SQL Server.
> I had done following task-
> - I had installed SQL-2000 (Ent. Edition) on Win-Server 2003. And it is
> successfully installed.
> - In Win-S-2003 with the help of Active Directory I created domain and
> created user on it.
> - Client computer (Win-XP Prof.) configured with domain system. and I can
> successfully login on that computer as a administrator.
> - On client computer installed Sql-2000 (Ent. Edition) client tool.
> - In Client Network Utility Configured my SQL Server
> - In Enterprise Manager I done new registration with following configuration
> -- Connect using = window authontication
> -- Here I found following error : SQL Server does not exist or
> access denied Connection Open(Connect())
> Please help me to connect my client.
>
> Hardik.
>
>
|||Hi,
Thanks for your reply.
I don't know how ping work . Please tell me how can client ping the SQL
Server
Hardik Shah
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:99ED019E-B7C0-473F-90D2-1AB2B7C059FC@.microsoft.com...[vbcol=seagreen]
> Hi
> Can you connect to SQL Server, though EM, from the SQL Server console?
> If not, is SQL Server running?
> Can the client ping the SQL Server server?
> Regards
> Mike
> "Hardik Shah" wrote:
can[vbcol=seagreen]
configuration[vbcol=seagreen]
|||Yes, I tried to ping my server it run successfully..
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:99ED019E-B7C0-473F-90D2-1AB2B7C059FC@.microsoft.com...[vbcol=seagreen]
> Hi
> Can you connect to SQL Server, though EM, from the SQL Server console?
> If not, is SQL Server running?
> Can the client ping the SQL Server server?
> Regards
> Mike
> "Hardik Shah" wrote:
can[vbcol=seagreen]
configuration[vbcol=seagreen]

Friday, February 10, 2012

cli for MSSQL server?

I need to put a series of records in two columns of an
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
UsarianWhat happens if you try to run DTSWiz.exe from Start -> Run
?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Usarian" <usariankristine@.juno.com> wrote in message
news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
I need to put a series of records in two columns of an
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
Usarian|||File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian
>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->
Run
>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>|||Then consider installing SQL Server client utilities on this machine.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
<anonymous@.discussions.microsoft.com> wrote in message
news:176101c3dfad$1e3e1ff0$a401280a@.phx.gbl...
File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian
>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->
Run
>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>