Weird BCP Issue

Hi Steve,

Thank you for using the Microsoft MSDN Managed Newsgroup. My name is Mark
Han. I am delighted to work with you on this issue.

From your description, I understand that after using BCP to input data from
CSV to SQL Server table, the first field begins with "n++".
Based on my experience, it is so strange. if the issue is related to the
type of the data, the first column data should all begin with "n++".
So to better understand the issue, if it is convenient to you, please send
me a sample of the CSV file and a sample of the table.

my email address is v-fathan.DeleteThis@online.microsoft.com(remove online). after
receiving your email, I will create a work space for you and then you can
upload the required files

If there are any additional questions or concerns, let me know.

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg.DeleteThis@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 >> Stay informed about: Weird BCP Issue 

Thanks very much for your reply. Yes, this is a weird one! I hope it doesn't
turn out to be something stupid that I've done!!!

I've emailed you the files so you can see if you can reproduce the bug.

Many thanks,

Steve.

"Mark Han[MSFT]" wrote:

> Hi Steve,
>
> Thank you for using the Microsoft MSDN Managed Newsgroup. My name is Mark
> Han. I am delighted to work with you on this issue.
>
> From your description, I understand that after using BCP to input data from
> CSV to SQL Server table, the first field begins with "n++".
> Based on my experience, it is so strange. if the issue is related to the
> type of the data, the first column data should all begin with "n++".
> So to better understand the issue, if it is convenient to you, please send
> me a sample of the CSV file and a sample of the table.
>
> my email address is v-fathan.DeleteThis@online.microsoft.com(remove online). after
> receiving your email, I will create a work space for you and then you can
> upload the required files
>
> If there are any additional questions or concerns, let me know.
>
> Best regards,
> Mark Han
> Microsoft Online Community Support
> ===========================================================
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg.DeleteThis@microsoft.com.
> ===========================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
>
> Note: MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 2 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions. Issues of this
> nature are best handled working with a dedicated Microsoft Support Engineer
> by contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx.
> ============================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
> =========================================================
>
>
 >> Stay informed about: Weird BCP Issue 

Hi

I have re-produce the issue on my work machine. It seems to be a
known-issue.

For your convenience, I'm consulting with our dev team now. If updating
anything, I will send an email to you.

Besides, if it is convenient to you, could you please create a SSIS
package to copy the data from AgentData.csv to AgentData table. The issue
might not happen in the scenario.

Besides, about the SSIS package, there are serveral articles to share with
you:
SSIS package could be developed with SQL Server Business Intelligence
Development Studio. For your convenience, I would like to share some
general article with you:
How to: Create a Package Using SSIS Designer:
http://msdn.microsoft.com/en-us/library/ms141178(SQL.90).aspx
How to create a package template in SQL Server Business Intelligence
Development Studio: http://support.microsoft.com/kb/908018
SSIS Team Blog: http://blogs.msdn.com/mattm/
dtutil Utility:
http://msdn.microsoft.com/en-us/library/ms162820(SQL.90).aspx

Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg.TakeThisOut@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 >> Stay informed about: Weird BCP Issue 

Mark,

Is there a reference to the known issue? If so, I would like to read it.

RLF

"Mark Han[MSFT]" wrote in message

> Hi
>
> I have re-produce the issue on my work machine. It seems to be a
> known-issue.
>
> For your convenience, I'm consulting with our dev team now. If updating
> anything, I will send an email to you.
>
> Besides, if it is convenient to you, could you please create a SSIS
> package to copy the data from AgentData.csv to AgentData table. The issue
> might not happen in the scenario.
>
> Besides, about the SSIS package, there are serveral articles to share with
> you:
> SSIS package could be developed with SQL Server Business Intelligence
> Development Studio. For your convenience, I would like to share some
> general article with you:
> How to: Create a Package Using SSIS Designer:
> http://msdn.microsoft.com/en-us/library/ms141178(SQL.90).aspx
> How to create a package template in SQL Server Business Intelligence
> Development Studio: http://support.microsoft.com/kb/908018
> SSIS Team Blog: http://blogs.msdn.com/mattm/
> dtutil Utility:
> http://msdn.microsoft.com/en-us/library/ms162820(SQL.90).aspx
>
> Best regards,
> Mark Han
> Microsoft Online Community Support
> =========================================================
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg.TakeThisOut@microsoft.com.
> =========================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> =========================================================
>
 >> Stay informed about: Weird BCP Issue 

Hi RLF,

Because of the holiday, I haven't got a update from our dev team. and if
our document team will public an artilce about the issue is based on a lot
of elements.
I will forward your requirement to them. if they send a feedback to me, i
will public it as soon as possible.

Thanks.


Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg RemoveThis @microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 >> Stay informed about: Weird BCP Issue 

Yes, please keep me in the loop with what happens with this, as we are going
to need a fix at some point soon.

Many thanks,

Steve.

"Mark Han[MSFT]" wrote:

> Hi RLF,
>
> Because of the holiday, I haven't got a update from our dev team. and if
> our document team will public an artilce about the issue is based on a lot
> of elements.
> I will forward your requirement to them. if they send a feedback to me, i
> will public it as soon as possible.
>
> Thanks.
>
>
> Best regards,
> Mark Han
> Microsoft Online Community Support
> =========================================================
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg.TakeThisOut@microsoft.com.
> =========================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
> =========================================================
>
>
 >> Stay informed about: Weird BCP Issue