Advertisement

12.04.2007 at 04:21AM PST, ID: 22999946
[x]
Attachment Details

SQL SSIS import fails due to bad format on rows

Asked by JFMConcepts in MS SQL Server, MS SQL DTS, SQL Server 2005

Tags: ssis, import, sql

SQL SSIS imports fail if any of the rows are misformatted.  Access simply logs the rows it cannot import and skips them.  SQL Management Studio fails the whole operation.  

Is there any way to set Management Studio up so that it just puts aside bad rows?  I know this can be done in SSIS package code, but that is a pain.  Anyways, even that fails the whole package for many format issues.

I have been looking high and low for an answer to this issue and cannot find one.

Thanks,
JohnStart Free Trial
 
Keywords: SQL SSIS import fails due to bad format…
Title
1 Process Fixed length file in SSIS
2 Trying to Query 'Active Directory' in…
3 SSIS t-SQL
4 Can't find SSIS
5 SSIS: insert AND delete rows
6 Force an SSIS pkg step to FAIL
 
Loading Advertisement...
 
[+][-]12.04.2007 at 05:52AM PST, ID: 20402677

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.04.2007 at 06:57AM PST, ID: 20403212

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.04.2007 at 07:01AM PST, ID: 20403257

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.08.2007 at 08:44AM PST, ID: 20434472

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.10.2007 at 09:07AM PST, ID: 20443177

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.10.2007 at 09:21AM PST, ID: 20443296

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.10.2007 at 10:47AM PST, ID: 20444006

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 07:21AM PDT, ID: 21385998

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.12.2008 at 01:33PM PDT, ID: 21990305

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, MS SQL DTS, SQL Server 2005
Tags: ssis, import, sql
Sign Up Now!
Solution Provided By: JFMConcepts
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.22.2008 at 05:53AM PDT, ID: 22058768

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 11:00AM PDT, ID: 22072010

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 11:03AM PDT, ID: 22072040

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 05:53PM PDT, ID: 22075347

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 05:56PM PDT, ID: 22075372

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 07:02AM PDT, ID: 22079181

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628