Things that usually cause problems for me

- Amount of data in source table

- View pulling from another server

- Need an index hint

- View contains bad joins

- Available Server space is...

I found this post that helped fix my issue:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/bcae9086-4345-4c59-8dd8-9ddeca4edc45/[/url]

IT basically says to update the Path System Variable so it finds the BC elements before it finds the new stuff:

After changing...

I am having this issue on a win7 x86 non-itanium system. Has anyone had any luck with Compatibility mode installations?

I have the answer for the date part of the question; we have some tables with the same date style.

we use the convert function to get it into a datetime...

I am attempting this same thing and cant seem to follow what you are discussing about the GUIDs. After copying the project my Visual Studio wont open the SSIS...

Thanks for all the insights and tips.

RESULT: Since it was a mutual miscommunication. We sat down and determined an acceptable number of hours and schedule to...

I have found that there are invisible characters from the original copy and paste from the original posting. I copied the script into Notepad and removed the "Box Characters"...

so what updates did you make to get the script to work then? I can get the inidividual pieces to run, but cannot get the full script to produce...

so what updates did you make to get the script to work then?

I am experiencing this same issue, except that the granted permissions were never visible when reviewing them later. Any insights would be appreciated.

Thanks, Scott:sick:

DBCC CheckDB gives this ever so helpful message...

Server: Msg 7995, Level 16, State 1, Line 1

Database 'SGR_2008' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing.

??!?!??! ...

When the attempt to drop the index is made we get the following message.

Server: Msg 644, Level 21, State 3, Line 1

Could not find the index entry for RID '160a1b727a010000'...

I attempted the shared url \\servername\share\directory\file.xls

and the DTS could not find the file, unless the share was physically on my SQL Server server.  Shares to other server directories did...

Erik,

That works great! I just had to add a Dynamic Properties Task to my actual DTS job and got the passed value to work.

Thanks.

That will get my dts import files...