Dataflow Tab:There is no ODBC Source option in the Toolbox

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - SQL Server 2005 Reports not displying properly in Mozilla Sql server 2005 Reports are not displaying properly in mozilla.What should I do to work It is working fine in IE. Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 2
    - Multiple Reports Have you tried changing the parameter to multi-value and the datatype to Integer Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 3
    - What is the best Backup strategy just to add few points to Arnie's comment... since it is small , i would say , if possible its always take full backup so that the recovery process will be easy. or even Differential Backup can be taken. TL backup will complicate the restoration process. If you don't want point in time restore then there is no need to take the backup of TL Madhu Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 4
    - SQL Server 2005 Express Edition with Advanced Services SP1 Sorry I didn't notice this earlier. In this case, Jens is not correct; the upgrade from SQL Express RTM to SQL Express Advanced SP1 is fully supported. I think the confusion is that there was a bug in the beta release of SQL Express Advnaced that prevented you from upgrading from the beta release to the final release of SQL Express Advanced. In general, you can always move up in Edition (i.e. SQL Express to SQL Express Advanced) as long as the Edition you are installing is at the same or higher service pack level (i.e. SQL Express RTM/SP1 to SQL Express Advanced SP1 will work, but SQL Express SP2 to SQL Express Advanced SP1 would fail.) Mike Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 5
    - Can not create a Full Text Catalog or Index When I try to create a full-text catalog on my local database I get an error that I can not find support information for. Here is the command I run : CREATE FULLTEXT CATALOG asset_search_values_catalog on FILEGROUP ftFileGroup IN PATH 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\' as default Here is the error message I get: Msg 7689, Level 16, State 1, Line 1 Execution of a full-text operation failed. 'No such interface supported' I check the properties of my database and Full-text is enabled. I am running SQL Server 2005, on an XP Pro, SP2. I had originially installed in side by side with SQL Server 2000. I even tried uninstalling SQL Server 2005 (to try a re-install), I could not even uninstall the database. What should I do. Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 6
    - Error: A deadlock was detected while trying to lock variable "x" for read access. A lock could not be acquired after 16 atte Jamie Thomson wrote: This is a known problem. There were fixes that went into the post-SP1 hotfixes to mitigate the risk of it happening. Have you installed that I recently switched workstations - hopefully installing SP will help. The SP1 for SQL Server 2005 right Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 7
    - how to pass strange looking Passwords to SQLCMD ? Thank you Jeff. "pass" works . Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 8
    - Load a XML file to a variable Thanks a lot for the reply!!! But this is what am trying to do.. I have a variable onto which am storing the complete path location where my XML file is stored. Say "C:\\Temp\\A.xml" I also have a Stored Proc in my Database that does accept an XML doc as an input parameter. Now is there a way I can pick the XML file load it onto a variable and pass it onto the Stored Proc Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 9
    - Copy and Past a row Hello Jens, I'm trap in a pure SQL query's world. Imagine you are performing the above task in SQL Server Management Studio. Best regards, Tee Song Yann Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 10
    - Excel export problem when matrixes are side by side If I export to excel ,when Report has two matrixes side by side datas are missed....Is there anything to do Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 11
    - PerformancePoint Configuration Error: Starting service: w3svc: StartServiceByName failed with HRESULT 8007041d I am configuring PerformancePoint Planning Server (CTP2) using configuration manager. It fails at the last step: Configuration failed. Error 1: Start registering ASP.NET scriptmap (2.0.50727) recursively at W3SVC/616204989/Root. Finished registering ASP.NET scriptmap (2.0.50727) recursively at W3SVC/616204989/Root. Setup has detected some errors during the operation. For details, please read the setup log file C:\DOCUME~1\SERVIC~1\LOCALS~1\Temp\1\ASPNETSetup_00001.log The environment is Windows Server 2003, IISv6.0. I checked IIS Manager: Web Sites Service Running, Default SMTP Virtual Server Running, ASP.NET v2.0.50727 Allowed Log file: ******************************************************************************** **** Starting ASP.NET Setup at: 2007-06-26 14:15:51 **** Registering ASP.NET isapi: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll **** Internal flags: 0x00000017 ******************************************************************************** 2007-06-26 14:15:51 Starting Querying status of a service: iisadmin 2007-06-26 14:15:51 Starting Connecting to Service Manager 2007-06-26 14:15:51 Success Connecting to Service Manager 2007-06-26 14:15:51 Starting Opening Service handle 2007-06-26 14:15:51 Success Opening Service handle 2007-06-26 14:15:51 Starting Finding out service state 2007-06-26 14:15:51 Success Finding out service state 2007-06-26 14:15:51 Success Querying status of a service: iisadmin 2007-06-26 14:15:52 Starting Check the status of IIS 2007-06-26 14:15:52 Success Check the status of IIS 2007-06-26 14:15:52 Starting Querying status of a service: w3svc 2007-06-26 14:15:53 Starting Connecting to Service Manager 2007-06-26 14:15:53 Success Connecting to Service Manager 2007-06-26 14:15:53 Starting Opening Service handle 2007-06-26 14:15:53 Success Opening Service handle 2007-06-26 14:15:53 Starting Finding out service state 2007-06-26 14:15:53 Success Finding out service state 2007-06-26 14:15:53 Success Querying status of a service: w3svc 2007-06-26 14:15:53 Starting Determining if current ASP.NET isapi has the highest version 2007-06-26 14:15:53 Success Determining if current ASP.NET isapi has the highest version 2007-06-26 14:15:53 Starting Update IIS Metabase to use this ASP.NET isapi 2007-06-26 14:15:53 Starting Getting highest version information from registry 2007-06-26 14:15:53 Success Getting highest version information from registry 2007-06-26 14:15:53 Starting Registering scriptmap properties in IIS metabase 2007-06-26 14:15:54 Success Registering scriptmap properties in IIS metabase 2007-06-26 14:15:54 Starting Cleaning up security lockdown data in IIS metabase 2007-06-26 14:15:54 Success Cleaning up security lockdown data in IIS metabase 2007-06-26 14:15:54 Starting Modifying security lockdown data in IIS metabase 2007-06-26 14:15:54 Success Modifying security lockdown data in IIS metabase 2007-06-26 14:15:54 Success Update IIS Metabase to use this ASP.NET isapi 2007-06-26 14:15:55 Starting Restarting W3SVC 2007-06-26 14:16:00 Starting Connecting to Service Manager 2007-06-26 14:16:01 Success Connecting to Service Manager 2007-06-26 14:16:01 Starting Opening handle to W3SVC 2007-06-26 14:16:01 Success Opening handle to W3SVC 2007-06-26 14:16:01 Starting Stopping W3SVC 2007-06-26 14:16:01 Starting Finding out service state 2007-06-26 14:16:01 Success Finding out service state 2007-06-26 14:16:01 Starting Enumerating dependent services 2007-06-26 14:16:01 Success Enumerating dependent services 2007-06-26 14:16:01 Starting Stopping service 2007-06-26 14:16:01 Starting Finding out service state 2007-06-26 14:16:01 Success Finding out service state 2007-06-26 14:16:01 Starting Shutting down service 2007-06-26 14:16:02 Success Shutting down service 2007-06-26 14:16:02 Starting Waiting for service to shut down 2007-06-26 14:16:53 Success Waiting for service to shut down 2007-06-26 14:16:53 Success Stopping service 2007-06-26 14:16:53 Success Stopping W3SVC 2007-06-26 14:16:53 Starting Starting service: w3svc 2007-06-26 14:16:53 Starting Connecting to Service Manager 2007-06-26 14:16:53 Success Connecting to Service Manager 2007-06-26 14:16:53 Starting Opening Service handle 2007-06-26 14:16:53 Success Opening Service handle 2007-06-26 14:16:53 Starting Starting service 2007-06-26 14:16:53 Success Starting service 2007-06-26 14:16:53 Starting Waiting for service to start 2007-06-26 14:17:53 Failure Waiting for service to start: WaitForServiceState failed with HRESULT 8007041d: 'The service did not respond to the start or control request in a timely fashion. ' 2007-06-26 14:17:53 Failure Starting service: w3svc: StartServiceByName failed with HRESULT 8007041d: 'The service did not respond to the start or control request in a timely fashion. ' 2007-06-26 14:17:53 Failure Restarting W3SVC: RestartW3svc failed with HRESULT 8007041d: 'The service did not respond to the start or control request in a timely fashion. ' I am new to Microsoft development environment, detaled answer will be appreciated Thanks Habeeb Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 12
    - Dimension, CurrentMember and a hierarchy Greetings - I am writing some MDX for a RS report, and seem to have hit a bit of a wall. The business folks keep changing their minds on what hierarchy they want to report from, so I would like to have it as a parameter to the report. Problem is that I don't know if there is a way to get the CurrentMember.Properties('Caption') without explicitly declaring the hierarchy. My MDX: With Set [MySet] as StrToSet (@HierarchyAndMember) Set [DateSet] as StrToSet (@Date, Constrained ) Member [Measures].[Display] as [Dimension].[Hierarchy Name]. CurrentMember . Properties ( 'Caption' ) I would like to do StrToSet(@HierarchyMember).CurrentMember.Properties('caption') here Select { [measures].[created invoices], [measures].[display] } on 0, { [MySet] * [DateSet] } on 1 from [cube] I have tried several different things, and this is the closest I have found. Placing the StrToSet in either it's own set or directly in the MDX doesn't affect the results. Is there any way to get the current member of the dimension without hardcoding the hierarchy Does anyone have any creative solutions, or at least any directions to go Thanks in advance, John Hennesey Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 13
    - Tracking Execution Time of each step? Ah I see that now, its kind of hard to analyze from the Execution results view. Is there a way to output that information in some other format Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 14
    - Database save and restore Thanks Gos, I have this small database entry front-end binded to a database. When this is published and run, there is nothing the user can do except what is implemented on it, which is save, delete, add new record to the database. These seems to be working. When this is published, I can see the setup.exe. When it is run it does not seem to be installing anywhere, just opens up the program ready for action. Well, there is a shortcut in the StartMenu. In theVisual Studio\Project\MyFirstProject\ I can see the *.mdf file as well as in the Visual Studio\Project\MyFirstPoject\MyFirstProject\bin\Release\ Greetings. Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 15
    - ROW_NUMBER() paging - CTE or subquery ? For paging in SQL 2005, ROW_NUMBER() is recommended. But is it best practice to use that with a CTE or a Subquery I get the same query plan for the two examples below. One link I found suggests CTEs are preferred: http://weblogs.sqlteam.com/jeffs/archive/2007/03/30/More-SQL-Server-2005-Solutions.aspx Thoughts on this Thanks, Andy Mackie Code Snippet USE AdventureWorks ; GO --Using a CTE WITH OrderedOrders AS ( SELECT SalesOrderID , OrderDate , ROW_NUMBER () OVER ( ORDER BY OrderDate ) AS 'RowNumber' FROM Sales . SalesOrderHeader ) SELECT * FROM OrderedOrders WHERE RowNumber BETWEEN 50 AND 60 ; --Using a subquery SELECT * FROM ( SELECT SalesOrderID , OrderDate , ROW_NUMBER () OVER ( ORDER BY OrderDate ) AS 'RowNumber' FROM Sales . SalesOrderHeader ) OrderedOrders WHERE RowNumber BETWEEN 50 AND 60 ; Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 16
    - SIngle transaction batch script without go's ??? I am stumped. I open 2 sessions to the same database as the same user I execute the following on sessions 1: ============================================================================== BEGIN BEGIN TRAN CREATE TABLE TEST5 ( Col1 int ); INSERT INTO TEST5 VALUES ( 1 ); ALTER TABLE dbo . TEST5 ADD Col2 bit NULL; UPDATE TEST5 SET Col2 = 0 WHERE Col1 = 1 ; INSERT INTO TEST5 VALUES ( 2 , 1 ); COMMIT TRAN END ========================================================================================== Everything is successful. On session 2 i run the following: ========================================================================================== BEGIN BEGIN TRAN ALTER TABLE dbo . TEST5 ADD Col3 bit NULL; UPDATE TEST5 SET Col3 = 0 COMMIT TRAN END ========================================================================================== I get the following error: Invalid column name 'Col3'. Why can i create a new table and do whatever i want to it in a transaction, but i cannot alter and existing table and update the new column ina transaction Thanx Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
- Next
  - 1
    - How to create Report Model Project for OLAP Cube Hi , Please tell me how to create Data Source and Data Source View in Report Model Project for OLAP Cube.Whats the provider to use while creating Data Source in Report Model Project to make connection to OLAP Cube. Thanks Raghava Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 2
    - Log files grows indefinitely and causes ETL to fail Thanks Matt; Could you tell how can I reduce the number of events that's been logged Meaning- how can I turn it off Rok. Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 3
    - SSIS - Best way to copy files from one directory to another I would use the File System Task rather than script. It would take two operations to do the move and then the rename. Your configuration would place the directory name in a variable. Above you indicate that you have multiple directory names. If so, I would specify these together as a comma-separated string, then use a script task to split that string into an array that can be iterated by a For Each loop. Once you have the directory name in a variable either directly from the configuration or from a ForEach iterator, you would do a ForEach to iterate the files in the directory. Hopefully all your files have the same extension since it will make constructing the new filename much easier. If so, only get the filename without the extension from the ForEach into another variable. With the directory variable, the filename variable, and a hard-coded extension you can create expression-based variables to generate the source and destination names for a rename operation. The "destination" or the rename would also be the "source" of the move (or vice versa if you choose to do the move first). Another variable will probably be set from the configuration for the move destination folder. If you can't hard-code the extension in your expression to generate the new filename, then the expression will be more complicated as you have to insert the date into the filename before the extension. Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 4
    - MDX - Group By functionality Hello. I am currently trying to replicate a GROUP BY clause in MDX. Basically we have a Many-To-Many Dimension, with Planograms-Items as our hierarchy. When I say: { DESCENDANTS( [Planogram].[PLanogram1], [Planogram].[Items]), DESCENDANTS( [Planogram].[PLanogram2], [Planogram].[Items]) } I get duplicate items since an item is in both planograms, but of course each row has it own sales, units, etc. The problem is, when I submit larger queries I get 30,000 rows, 3,000 of which are unique Item ID's. I've tried a lot, SUM(), using STRTOMEMBER(), etc...but to no avail. Basically i'm looking to sum the rows in which the Item ID's are equal, and only get 3,000 rows back from the cube, with all the non description columns summed. ANy ideas Thanks a lot. Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 5
    - SQL Server 2005 Profiler - Newbie question Profiler works good.. A new method exists in SQl 2005, in the system view sys.dm_db_index_usage_stats ... An example of it's usage would be this query. select top 500 db . name , obj . name , * from sys.dm_db_index_usage_stats ius inner join sys.databases db on ius . database_id = db . database_id inner join sys.objects obj on obj . object_id = ius . object_id This view is refreshed each time SQL Server is restarted... You COULD restart SQL, then moniotr this system view for usage info... or Profiler it... Bruce Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 6
    - Parameterized connection string & parameters - problem Hi, I��ve created a report which utilizes two stored procedures to populate parameter dropdown and fill report itself respectively. Report works fine until I create parameterized connection string. When datasource (not shared) has parameterized connection the parameter dropdown is greyed. I��m getting error: ��error during processing of the ConnectString expression of the datasouree ��name��. It works fine when I��m using only one stored procedure (no parameter dropdown stored procedure is executed �C report has only one dataset). It looks like adding second dataset to use datasource with parameterized string spoils something. Any advices are welcome. Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 7
    - SQL Server 2005 Developer Ed Installation On Vista Business Ed 64 This sounds strange. When I have installed Sql 2005 on this Vista Machine and then applied SP2 it kills Vista to the point it wont even start in Safe Mode - It will come back when using Last Known Good Configuration but this leaves Sql Server without the SP2 and it doesnt run very well - Compatability issues and all. Tempted to go back to XP 64 where Sql 2005 ran without a hitch. Vista is a clean install - of course. Anybody got ideas PROBLEM SOLVED Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 8
    - Script Task scripts will not stop at breakpoints. I was in the process of deleting my other post when you replied. I didn't want to post in a thread that had something marked as an answer. Yes, this is for script tasks. I certainly could use MsgBox() but that is hardly an answer to this problem. I could also write text out to a file, call a web service, insert a record into a table, etc. None of those things take the place of stepping through code. Is there a fix in the works for this issue It really makes script tasks of limited use, or at least it makes them take much longer to develop. Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 9
    - Login failure issue with Crystal reports connecting to SQL Server 2005 What do you mean..."outside the application " It sounds like it's using impersonation or windows authentication. Please post your connection string without the login and password. Adam Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 10
    - Parse XML to load files inside them Thanks for the quick reply JayH will try n let it out Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 11
    - Browsing attributes from shared dimensions Hello, e.g : I have the dimensions order.date , delivery.date based on the dimension date. When i browse the date dimension in the cube browser or in excel, and i select the year attribute from the dimensions it just shows year in the browser and I really want it to show order.year and delivery.year Our real cube has more than 10 shared time dimensions, so it can be really confusing to users when they are browsing , does anyone has an answer Regards, Wout Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 12
    - Cannot connect to SQL Server 2005 Express with Management Studio Express Can you ping \\MPLIAM Try usingthe IP address rather than the server name. Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 13
    - password cannot be saved Thanks. Do you mean I need another password to open my package Where can I set the "ProtectionLevel" in the package Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 14
    - Unable to change SQL 2005 database Autogrowth through Server Management Studio Hi Akinja, So far the highest number I could input is 10000 for % of growth. Anything higher is automatically converted to 10000 when validation occurs. I'm following some other hunches as to how this number is getting set to something so high. Will let you know what I find out in the next few days. Terrence Nevins SQL Server Program Manager Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 15
    - Sorted Input Matt David wrote: This is actually by design. The layout code will check to see if you are seeing the input as sorted and return that information to you instead of the actual values that are on the upstream columns. I think this is best seen with an example. Say you have data from upstream sorted on ColumA (1) and ColumnB (2). If you mark that both columns are used (via SetUsageType) then you will get those SKP values and the IsSorted property will be true. However, if ColumnA is marked as ignored (not used) then the layout will see that you are not using the sorted column so to you the data is not sorted and, therefore, the layout will return that IsSorted is false. If, on the other hand, you had ColumnA as RO or RW (used) and ColumnB as ignored then you would get that IsSorted was true because you are looking at a column that does make the data seem sorted to you. This is also why the virtual input shows the SKPs. It is because all the columns are available so the data would be sorted while using those columns. HTH, Matt Hi Matt, Hopefully you're still getting Alerts on updates to this thread. If I read what you said above correctly, I need to check the virtual input in order to know for sure that the input is sorted. Is that correct Darren, how did you get round this problem I need to check that the input is sorted without the user having to select all the columns. Regards Jamie Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox
  - 16
    - Need to change Authentication type of my first DB in SQL05 Sql service is necessary after changing the authentication mode on server level. Hence do a restart after changing the authentication mode. Tag: Dataflow Tab:There is no ODBC Source option in the Toolbox

Mr Pro Tools

I need to extract data from tables in a database that I can only access via ODBC.

I have successfully created a connection in Connection Manager (ConnectionManagerType = ODBC) for this database.

However I��m unable to add this connection as a Data Flow Source. There is no ODBC Source option in the Toolbox.

This is a major because we have been using the system dsn Microsoft Visual Foxpro Driver to access free table directory .dbf files under ODBC with DTS for years. To install a new Microsoft OLEDB driver for foxpro is out of the question on a production system as it would cost many thousands of dollars to go through our BAT testing process

How do I extract data from tables in a database via ODBC

Thanks in advance

Dave

Re: Dataflow Tab:There is no ODBC Source option in the Toolbox

Phil Brammer

There is too, though it's not marked as such. Use the Data Reader Source.

Re: Dataflow Tab:There is no ODBC Source option in the Toolbox

Vijay Thirugnanam

You can use the script component as source.

Re: Dataflow Tab:There is no ODBC Source option in the Toolbox

Mr Pro Tools

Thanks for that ---the data reader souce can actually use a ODBC source. I have it working fine.

I do think there is a peformance overhead and its slower than the ODBC connector in DTS.

Re: Dataflow Tab:There is no ODBC Source option in the Toolbox

Mr Pro Tools

well that is interesting ---How can it connect to a foxpro file .dbf and matching .fpt file ---the .fpt files are used for memo text fields---the foxprpro ODBC driver does this for you behind the scenes

Re: Dataflow Tab:There is no ODBC Source option in the Toolbox

Phil Brammer

Vijay Thirugnanam wrote:
You can use the script component as source.

True, though it shouldn't be faster than using the prepackaged source connectors.