Viewing 15 posts - 9,466 through 9,480 (of 11,678 total)
Check out the following thread:
😉
May 5, 2011 at 6:29 am
Ah yes, property configurations. I forgot about them 😀
In the next version of SQL Server (Denali), this issue will go away. Handling Execute Package Tasks becomes a lot easier.
May 5, 2011 at 3:19 am
Regarding the debugging as a whole problem:
SSIS doesn't really support debugging/building a project as a whole. It is just an illusion 🙂
In SSIS 2005 and 2008, the basic unit of...
May 5, 2011 at 2:43 am
This is how I do it:
design your child packages and deploy them to the server.
Design your parent packages, set up the Execute Package Tasks and point to the child packages...
May 5, 2011 at 12:03 am
I also expect no significant troubles.
BIDS 2008 R2 is the same as BIDS 2008, so everything should be compatible.
May 4, 2011 at 11:59 pm
talha kamran (5/4/2011)
I am having the same problem.System.UnauthorizedAccessException: Access to the path is denied.
How to enable SQLServer to access local drives on server?
Thanks,
Kamran
The SQLServer service runs under a specific...
May 4, 2011 at 11:46 pm
Your explanation is very confusing. You should get your syntax straight.
If you want to do some transformations on the table, create a new dataflow, use that table as source for...
May 4, 2011 at 11:31 pm
So you have data in one table, you want to manipulate it with TSQL and put the results in another table.
I would use an Execute SQL Task.
May 4, 2011 at 6:59 am
Oh yeah, I forgot to mention:
SSIS holds the world record for fastest ETL.
Just saying 😀
May 4, 2011 at 1:32 am
Phil Parkin (5/2/2011)
SSIS Guy (5/2/2011)
Here is one more Tool to document ssis packagesIsn't that the same product as suggested by the previous poster?
You really don't get the concept of spamming,...
May 4, 2011 at 12:19 am
What is a table named query?
I only know about named queries in SSAS, so I'm not sure what it has to do with SSIS.
May 4, 2011 at 12:18 am
Maybe the problem isn't SSIS's fault.
How is the package created? What connectors did you use?
Did you do any transformations? Did you incorporate parallellism?
SSIS 2008 is also a bit faster. This...
May 4, 2011 at 12:16 am
GilaMonster (5/2/2011)
Woot!!!!!!!!!!http://www.allenkinsel.com/archive/2011/05/further-promoting-the-growth-of-speakers/
Congrats!
May 3, 2011 at 11:53 pm
SQLMyFriend (5/3/2011)
when you say, "the only variables that matter are those in the SSIS package itself."
But the variables in dtsconfig matter too,...
May 3, 2011 at 11:46 pm
Viewing 15 posts - 9,466 through 9,480 (of 11,678 total)