Viewing 15 posts - 9,271 through 9,285 (of 9,643 total)
In your dataflow your oledb piece is a destination thus it cannot be the source for a nother transform. In the COntrol Flow window add another dataflow task to...
January 11, 2008 at 10:03 am
Remoive the insert statement from your code so you can see the results of your query. You will see that you are getting multiple records returned by your select...
January 11, 2008 at 9:59 am
Profiler is probably going to be the easiest and fastest way to find the process causing the problem. Are you using sp_who or sp_who2 to find the blocking process?...
January 11, 2008 at 9:54 am
Are the report server database server and IIS server the same machine? If not you need enable kerberos within the domain in order to use a trusted connection. ...
January 11, 2008 at 9:44 am
Before killing the process that is holding the locks you can run DBCC InputBuffer([spid]) which will give you the last sql statement executed by the given spid.
January 11, 2008 at 9:27 am
I don't think you want to use the bulk insert task for this. The bulk insert task is expecting the source to have the same # of columns as...
January 11, 2008 at 9:12 am
How did you migrate the 2000 DTS packages to SSIS? Are you using the Execute DTS 2000 Pakcage Task or did you re-write the packages in SSIS?
January 10, 2008 at 10:26 am
Hey Brandie, this looks like a reporting services, not Integration Services question, but I'll give it a shot anyway.
What is being returned by the datasource in the planes row, empty...
January 10, 2008 at 10:22 am
When you create a package, at the bottom of the screen there is a tab titled Connection Managers, or in the menu SSIS -> New Connection. Professional SSIS By...
January 10, 2008 at 10:15 am
Yes. You would use the Flat File connection manager and set it to use a fixed width format and you can define the width of each column. The...
January 10, 2008 at 10:07 am
It may nort be timing out in Query Analyzer, but how long is it taking to run? The timeout settings on your connection from the PHP app may be...
December 26, 2007 at 8:18 am
From BOL:
The Attention event class indicates that an attention event, such as cancel, client-interrupt requests, or broken client connections, has occurred. Cancel operations can also be seen as part of...
December 21, 2007 at 12:26 pm
Yes you can install 2000 and 2005 on th esmae box. One needs to be a named instance. I would uninstall SQL Express (yes it comes with VS...
December 21, 2007 at 12:19 pm
Are you getting any errors when you run the stored procedure? or is the problem that you are not getting the results you expect or no results at all?
I...
December 21, 2007 at 12:13 pm
Viewing 15 posts - 9,271 through 9,285 (of 9,643 total)