difference between BCP and DTS

Hi Experts,
please tell me the difference between BCP and DTS

provide me links if possible.

thankyou very muchHai friend

refer this link
http://www.google.co.in/search?hl=en&q=difference+between+BCP+and+DTS&meta=

thanks
Vssp

Diff Result Between SQL 7 & SQL 2000

Hi.

When I execute the following sql statement in SQL 2000 DTS or query analyzer, I received the following error message. I used [ ] because my field names have spaces in between.

The same sql statement ran perfect in SQL 7. What could be wrong? Please advise. Thanks a million.

Update SAPvsSQL set [Sales Organisation] = sales_org,
[Value Out By] = val_diff, [Qty Out By] = qty_diff

Error message:

Server: Msg 16882, Level 11, State 1, Procedure sp_runwebtask, Line ...

SQL Web Assistant: Web task not found. Verify the name of the name for possible errors.

Best regardsYou sure you just didn't execute all of the code in the QA window, and you're executing something you don't see?|||And also, what are you setting the columns to?

Those aren't local variables...is there more to the statement?|||Originally posted by Brett Kaiser
And also, what are you setting the columns to?

Those aren't local variables...is there more to the statement?

Hi,

Thank you for your email reply.

Those in [ ] were actual field names in my database table. I used them for display purposes so instead of showing Sales_organation, I display Sales Organisation, Value Out By instead of val_diff and finally Qty Out By instead of qty_diff (look more meanful to the users).

You are right that I didn't show all the script in my previous message because they worked ok until this line. I am just being curious why the same script work PERFECT in SQL 7 but not in SQL 2000. I have been running this same set of script for more than a year and still running fine as at this morning. Reason why I am trying it on SQL 2000 because we will be moving to SQL 2000 totally by end this month.|||No problems here...your doing something else wrong...

USE Northwind
GO

CREATE TABLE SAPvsSQL (
[Sales Organisation] varchar(10)
, [Value Out By] varchar(10)
, [Qty Out By] varchar(10)
)
GO

DECLARE @.Sales_Org varchar(10), @.val_diff varchar(10), @.qty_diff varchar(10)

SELECT @.Sales_Org = 'A', @.val_Diff = 'B', @.qty_diff = 'C'

INSERT INTO SAPvsSQL ([Sales Organisation], [Value Out By], [Qty Out By])
SELECT 'X', 'Y', 'Z'

SELECT * FROM SAPvsSQL

UPDATE SAPvsSQL
SET [Sales Organisation] = @.sales_org
, [Value Out By] = @.val_diff
, [Qty Out By] = @.qty_diff

SELECT * FROM SAPvsSQL
GO

DROP TABLE SAPvsSQL
GO

developing custom components by extending the SSIS stock data flow components

Everything I've read says that custom data flow components are built by inheriting from the Microsoft.SqlServer.Dts.Pipeline.PipelineComponent class.

But the stock components such as the Derived Column data flow transformation must each be implemented by their own class. So how do I base my custom components on those classes? The documentation for the PipelineComponent class doesn't list any such subclasses.

Not possible unfortunately. Those classes are not overrideable.

There is functionality hopefully coming in the next version which may mean this is possible (although via a slightly different method).

-Jamie

Developing app that will use SQL Server Express on back end...

Hi...

I have the full version of SQL Server installed on my machine and am developing an app using BI DTS packages, VB.Net, SQL SPs, etc.. I will need to deploy this app w/SQL Server Express (SSE).

-Do I have to install SSE on my development machine for the purpose of creating the install package of my application? I am afraid that if I do install SSE on my machine, it may mess up my installation of the full version of SQL Server... will it?

-Can you point me to a link with information about how to do the development with the full version of SS, and create the installation package using the SSE?

Thanks for your help.

Steph
You cannot deployment SQL Server 2005 Integration Services packages in SQL Server Express because the runtime now comes with the server license. In SQL Server 2000 the DTS package comes with the runtime that changed in 2005. Hope this helps.|||Thanks for the response.

The way I posed my question was misleading. I'm sorry about that. I shouldn't even have mentioned the DTS packages.

The big picture of the app is this:

- Data resides in a datamart at a central office. The central office will be running the full SQL Server 2005 version (this is where the DTS packages reside and run).

- Satellite (very small) offices need to download updated information relating to them from the central office. I'm thinking of having these satellite offices run SQL Express.

I'm developing the code to update the satellite office data from the central office data. On my development system, I am running the full version of SQL Server 2005. Should I also install SQL Express on my development system ? Will it mess up my full SQL Server 2005 installation?

Thanks,

Steph
|||It is tricky but here is how you could do it legally create Asp.net application run it from your main office SQL Server create a job to execute the many versions of the package make your small offices destination. It will take more work but the alternative solution may cost you more hardware SQL Server Express can be a subscriber in replication so you can push the data with replication. You could always talk to your local Microsoft SQL Server contact person, in some areas there is regional contact person. Hope this helps

Developer and DTS rights

To adhere to corporate security policies we have removed the guest
account from msdb. This has resulted in developers not having the
ability to view any dts packages on the server. We have multiple
development groups and a large amount of databases on the server.
Does anyone have a solution to this situation that we could use?
Thanks in advance, Markassign a security group a login to the sql server,
grant dbaccess to the msdb database for that user.
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Mark Anderson" <magnm01@.wellsfargo.com> wrote in message
news:ac3d559a.0401141350.68879fa9@.posting.google.com...
> To adhere to corporate security policies we have removed the guest
> account from msdb. This has resulted in developers not having the
> ability to view any dts packages on the server. We have multiple
> development groups and a large amount of databases on the server.
> Does anyone have a solution to this situation that we could use?
> Thanks in advance, Mark

Developer and DTS rights

To adhere to corporate security policies we have removed the guest
account from msdb. This has resulted in developers not having the
ability to view any dts packages on the server. We have multiple
development groups and a large amount of databases on the server.
Does anyone have a solution to this situation that we could use?
Thanks in advance, Markassign a security group a login to the sql server,
grant dbaccess to the msdb database for that user.
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Mark Anderson" <magnm01@.wellsfargo.com> wrote in message
news:ac3d559a.0401141350.68879fa9@.posting.google.com...

quote:

---

> To adhere to corporate security policies we have removed the guest
> account from msdb. This has resulted in developers not having the
> ability to view any dts packages on the server. We have multiple
> development groups and a large amount of databases on the server.
> Does anyone have a solution to this situation that we could use?
> Thanks in advance, Mark

---