How do I turn OFF the automatic validation when I open a package in VS to make changes?

Question

How do I turn OFF the automatic validation when I open a package in VS to make changes?

d_george

SSCrazy

Points: 2462
More actions
April 1, 2008 at 5:56 am

#124625

I have a package that has quite a bit in it.
When I open it in VS to make a change it takes freaking forever for it to go thgough validating the parts.
I know there is a way to turn the opening validation off becuase I have done it before but cannot find it now.
Please help!

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Chinna SSCertifiable Points: 5408 More actions · Answer 1

hey george what do u mean by that ,....when u open the package in vs it gets executed is that so....if so plz let meknow where can i set that option if u got the answer .....

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

d_george SSCrazy Points: 2462 More actions · Answer 2

Hi

No execution.

When I open the package, in the bottom left corner of vs it reads "validating blah..."

The more items in there the more it has to validate which is where the slowness is coming from.

I want to turn off the validation of things when it it opened for editing.

Chinna SSCertifiable Points: 5408 More actions · Answer 3

but george thanks for ur info but it doesnt show up for me in BIDS when i open the package it jus shows ready thast it ...,may be it has turned off in my casse but what is the use of turning it on or off can i know that ....

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

d_george SSCrazy Points: 2462 More actions · Answer 4

I'm sorry, I don't believe I understand what you are trying to say.

If you are asking why I want to turn that validation when I open a package to continue developing off, it is because it takes a very long time to iterate through all of the objects.

Chinna SSCertifiable Points: 5408 More actions · Answer 5

I'm sorry, I don't believe I understand what you are trying to say.

If you are asking why I want to turn that validation when I open a package to continue developing off, it is because it takes a very long time to iterate through all of the objects.

so do you know where can u make the validation turned off ???

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 6

Michael Earl-395764

SSC Guru

Points: 53873

April 1, 2008 at 8:11 am

#796511

Use the "DelayValidation" property on the package.

SSIS\SSRS\SSAS SSCertifiable Points: 6038 More actions · Answer 7

I am confused here.

i thought "The delay validation" property applies when running the package or when you are building the package. it just not validates any connection or any other execuatbles when set to true.

what does it had to do with the opening of the packages in vs.

thanks

Chinna SSCertifiable Points: 5408 More actions · Answer 8

may be go through this gyannedra u shall get an idea i m sure

http://wiki.sqlis.com/default.aspx/SQLISWiki/DelayValidation.html

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

SSIS\SSRS\SSAS SSCertifiable Points: 6038 More actions · Answer 9

Hey Chinna , Thanks for the input. But , U know i don't see any "Validating...........", when i open my package in BIDS. may be my package are simpler and small. ( from where i see, u r trying to tell that when u open the package in BIDS, it validates all the connections and so on...).

Thats very true.

But once u build and save ur packages and reopen it without any edits, all connections are alreday cheaked and validated and depending on that u have validation warnings. The real problems arises when u execute it , when it tries to validate for second time.

Thanks

Chinna SSCertifiable Points: 5408 More actions · Answer 10

thats what if the delay validation is set to false it validates 2 times ...on ei s before the execution during pre-execution and whill executing the package anyway i am not an expert in ssis but i am jus posting my ideas which i believe are true if not u can twist my arms at any time ....

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

SSIS\SSRS\SSAS SSCertifiable Points: 6038 More actions · Answer 11

My intenstions are not bad. ANYway, can u think u can solve this issue that i have posted here too.???

---------------------------------------------------------------------------

hi, all

i have a txt file - and i am trying to load data into sql destination table

text qualifier= none

header row delimeter = CR-LF

column delimeter = |

row delimeter = CR-LF

I get these error when i am trying to make my connections. on the column tab the columns are mismatched. However in DTS the same file works fine with same configurations---

TITLE: Microsoft Visual Studio

------------------------------

The last row in the sampled data is incomplete. The column or the row delimiter may be missing or the text is qualified incorrectly.

------------------------------

Here is little sample from file

01|2341390|03/30/2008|ajmeayworga@comcast.net|Y|SFX2DP||0

05|98741H

01|2341458|03/30/2008|BJM023655@aol.com|Y|SFX3DP||0

05|LCS4800

05|HOL4900

01|2341478|03/30/2008|iarunanplegs@yahoo.com|N|SFX3DP||0

02|TKAHM10001

03|$40 Unlimited Text Talk and Unlimited Picture Talk

01|2341485|03/30/2008|hervbwedissg@earthlink.net|N|SFX3DP||0

02|CDM1450M

ANY HELP WILL BE HIGHLY APPRECIATDE!!!!!!!!!!! THANKS

Chinna SSCertifiable Points: 5408 More actions · Answer 12

i think the problem is that in the second row you have jus two columns thats where the error occurs so it consider two columns of the second row and the next(3rd) row 1st column as 2nd row 3rd column...thats the reason when i imported i got the output in this way ...

01234139003/30/2008ajmeayworga@comcast.netYSFX2DP0

0598741H 01234145803/30/2008BJM023655@aol.comYSFX3DP|0

05LCS4800 05HOL4900 01234147803/30/2008iarunanplegs@yahoo.comNSFX3DP||0

02TKAHM10001 03$40 Unlimited Text T234148503/30/2008hervbwedissg@earthlink.netNSFX3DP||0

when i imported making the truncation error to ignore failure and run this i got imported this way ...so u just make changes to the text file such as

01|2341390|03/30/2008|ajmeayworga@comcast.net|Y|SFX2DP||0

05|98741H||||||

01|2341458|03/30/2008|BJM023655@aol.com|Y|SFX3DP||0

05|LCS4800||||||

05|HOL4900||||||

01|2341478|03/30/2008|iarunanplegs@yahoo.com|N|SFX3DP||0

02|TKAHM10001||||||

03|$40 Unlimited Text Talk and Unlimited Picture Talk

01|2341485|03/30/2008|hervbwedissg@earthlink.net|N|SFX3DP||0

02|CDM1450M||||||

try changing the flat file in this way it works i tried it ...it went through with out any error

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

SSIS\SSRS\SSAS SSCertifiable Points: 6038 More actions · Answer 13

HEY Chinna Thanks ( I can tell u that u r are hard worker). Thats defenately true its works. we tried it before. The problem is --this is impossible with thousands and millions of rows. we cannot change each row like that. You know what try that in DTS2000 its works absolutely fine without any modifications. Things are different in SSIS. Other solutions are --

You can open with Excel and change the | delimeter with tab or something else and asve, its works too.

SOme other solutions that i went through postings were replace the last row with abckspace.

I know here the problem is that the SSIS is expecting a valued row delimiter so when it doesn,t see in 2 nd row its combines another row till it finds |.

(Hey CHinna if i am sounding real expert , forgive my tone, As a matter of fact i AM rokiee in SSIS)

Thanks

Chinna SSCertifiable Points: 5408 More actions · Answer 14

i dont have any knowledge on dts i started working directly on ssis this is my first project and

even i was about to say the same solution which u came up with if you have many rows export it to excel file and then import to DB using ssis or place the carriage return at the end of the row and even i tried checking the retain nulls but even tat doesnt work i am not sure is there any other way if u know please let me know anytime seems like ur pretty good at ssis ....can i have ur mail id becoz if i get some issues when i cant rresolve it i shall mail to u ...

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman