What your suggesting isn't possible. If you change the data souce / destination you need to open the project and update the components. Mainly because SSIS is very strick on...

Thanks for the tip on the DTC, I'll have to check into that.

just to clarify the delay validation has nothing to do with loading a package into VS. This is...

Frank,

I did map all my guids to strings. Thanks for the confirmation.

Like you said unintuitive.

Thanks - Tom

Can you run the package in BIDS on the dev server?

thanks for the replies. I believe there was corruption in the package. I recreated and now the stored procedure runs.

I'm at a loss on this one. Not sure what...

It shows up in the profiler log and the call is fully qualified. It's using integrated authentication on my local sql server of which I am a sysadmin.

I checked the...

Here's my technique:

Read in the new data. Make sure you have a key that exactly matches the format / datatypes of the existing data, if not use conversions / derived...

Thanks CozyRoc, that was a good discussion.

The most interesting was the part about the package owner ID being used to define the temp directory path. I will need to investigate...

Paul,

Thanks for the perspective. That really helped.

paul,

Thanks for the explanation. That is very helpful. If you wouldn't mind to answer one last question. Would you ever make a NC index (in my case) with 35 included...

I appreciate all your help. I apologize for the the lack of information.

In the future I will try to post more relevant information if possible.

It is the privacy, one in a million shot the wrong person will see and know what it means but can't take that chance.

I know how it's just the meta data is too sensitive for certain reasons.

I have attached some screenshot that may be more helpful

Paul,

I just realized why it switched to a scan. The date field that is in the table (and first field of index) is a character and in my where clause...

Paul, I appreciate the offer but can't upload a plan. I did attach a screenshot

I would be willing to give you any info you want though.

Also since I have been...