Viewing 15 posts - 31 through 45 (of 65 total)
The first thing I have found with SSIS packages is that the security permissions between the BI studio and SQL are different so you need to make sure that the...
June 27, 2007 at 5:03 pm
The first thing I would do would be to add a data viewer to the flow to see that the data is actually getting pulled out of excel correctly. (You...
June 26, 2007 at 5:41 am
Can you possibly provide more details of the error message youa re receiving as well as your environment?
I have often found that when all else fails - scripting out,...
June 26, 2007 at 5:26 am
Hi Mohamed,
Although I am relatively new to the mobile dev world - I am curious as to why you would want to use another DB? The SQL 2005 CE version is...
June 26, 2007 at 5:19 am
Fair enough in alot of cases. NULL is a valid field content - but in some circumstances I think that Null is allowed in fields that shouldnt warrant it - and if you...
May 22, 2007 at 5:19 pm
I've used ClickYes for this - but I dont like it as a solution - as it bypasses the entire reason that the Pop up is there for! To stop...
May 20, 2007 at 10:40 pm
You could try giving the user that the package is set up to run as sysadmin access.
May 20, 2007 at 10:35 pm
If you have access to the tables, I would change the default for that field to be 0 - and stop it from allowing nulls - hence fixing the problem...
May 20, 2007 at 10:32 pm
You will most likely need to download the DTS tools for SQL 2005. You can get these from:
http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_DTS.msi (x86 version)
May 20, 2007 at 10:28 pm
Hi Jerry,
This depends on what type of replciaiton you are using. With Merge Replication you can still access the tables on Server B without issue.
HTH
May 1, 2007 at 6:40 pm
This message can appear if your SQL Server Agent Service is not started.
The SQL server agent is not enabled by default so you will need to go into your Surface Area...
April 30, 2007 at 7:49 am
OK they are on their way.
April 25, 2007 at 8:15 am
My Pictures havent uplaoded so let me know if you need the screenshots and I can email them to you directly?
April 25, 2007 at 8:09 am
no worries.
One thing to remember is that you can access the variables as parameters in the lookup tool - it is just a bit hidden:
Add a lookup task...
April 25, 2007 at 8:08 am
I have actually used this reference before and found it really helpful - maybe it will help?
April 25, 2007 at 7:41 am
Viewing 15 posts - 31 through 45 (of 65 total)