Qiuwei
Hi, there;
I try to import data from ODBC using C# programmatically. Is there any sample code we can have a look. Like how to read schema from ODBC source table and then create source column...
Thanks
Sample code to importing data from ODBC
SQL Server Integration Services
-
- Previous
- 1
- mobile phone and databases I did not get your point. What are you trying to do Sending a message to a Service, processing it in the database and sending the processed data, evtl. with a customized text back to the caller Data integrity should be maintained either through constraint rules (Whatever rules you have) or your logic you are trying to implement in the midtier or the database level. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Sample code to importing data from ODBC
- 2
- Howto get the result from two columns? You have to use the temp table instead of table variable. Code Snippet DECLARE table #TIME ( ID int , REP_TIME int , GO datetime , MYVALUES datetime , START_TIME int , MYTESTVALUE tinyint ); INSERT INTO #TIME EXEC TEST . dbo . GIVEMEMYVALUES SELECT * FROM #TIME Tag: Sample code to importing data from ODBC
- 3
- Change Flat File Source Dynamically You can set the ConnectionString property of your flat file connection managers to be based on an expression, which is in turn based on a package variable. You can then set the value of the variable from the command line when you run DEXEC. You can also use the Foreach Loop container to loop through all of the files in a given folder, and use the package variable as the loop enumerator, so that it will be automatically set to the name of the current file. If you know that files that are of a given format from a given client will always be in a specific folder, this might eliminate the need to have a custom UI and rely on operator input to kick off the ETL process. I don't know if this makes sense for your environment, but it sounds attractive to me. I have not personally used the .NET API to execute packages, so I cannot comment on that approach. Tag: Sample code to importing data from ODBC
- 4
- How to check multiple records with one query Which version of SQL Server you are using What is the input format of XML (sample input) Tag: Sample code to importing data from ODBC
- 5
- Cannot Deploy Report - Please Help Hi Troy23 I don't know if this will help but change the http://localhost/reportserver to http://ipaddresss/reportserver or http://servername/reportserver . Hope it helps, Kind Regards, Joos Nieuwoudt Tag: Sample code to importing data from ODBC
- 6
- Query Performance - SQL Server 2005 Hi, I am having a table with 40 columns and it contains 4 million records. I got the results for one year in 40 secs (as date parameter). After tuning, it is retuning in 24 secs( what i have done is i created index on order by fields). Can you please suggest me in which way I can increase the performance. Note: I am using only one table with Primary Key. Thanks Dinesh Tag: Sample code to importing data from ODBC
- 7
- Analysis Services Performance 102 cubes does sound a little extreme. I need to ask, are you running 2005 or 2000 Also are you running anything else on the box SSRS B. Tag: Sample code to importing data from ODBC
- 8
- 70-431 (MCTS - SQL 2005) If you're looking for brain dumps this is not the site to get those answers. The 70-431 exam is a 200-level "how-to" exam on all the nuts and bolts of SQL Server 2005. There are free eLearning classes available on the Microsoft web site which will help you with the content information for the test, as well as a number of excellent books hitting the market about now. I believe you'll get about 40 questions on the test, though it may be higher than that, and you'll get about 2 1/2 hours to answer them. Go to www.microsoft.com/sql and click on Learning and you'll find out all you need to know to prepare for the test. Good luck. Tag: Sample code to importing data from ODBC
- 9
- How do I not show a field if the field contains nothing? To account for a null or empty string in address2... =RTrim(Fields!FirstName.Value) & " " & Fields!LastName.Value & vbCrLF & Fields!Address1.Value & vbCrLF & IIF(Fields!Address2.Value Is Nothing Or Fields!Address2.Value = "", "", Fields!Address2.Value & vbCrLF) & RTrim(Fields!City.Value) & ", " & Fields!State.Value & " " & Fields!ZipCode.Value Tag: Sample code to importing data from ODBC
- 10
- Remote Connections using SQL Server 2005 Developers Enterprise Edition Hi, have you refered below links http://blogs.msdn.com/ sql express / archive/2005/05/05/415084.aspx http://support.microsoft.com/kb/914277/en-us Hemantgiri S. Goswami Tag: Sample code to importing data from ODBC
- 11
- Non-queried Parameters and what happens if you just enter "001,002,003" as the value assuming the datatype is string Tag: Sample code to importing data from ODBC
- 12
- MS SQL installation error Was there a work-a-round for this I have found only two references to this error, both without resolution :-( Currently getting same error on Windows 2003 64Bit - SQL2005 install also on cluster... Regards Rod Tag: Sample code to importing data from ODBC
- 13
- Display DB Table in ASP What about: http://www.stardeveloper.com/articles/display.html article=2002061201&page=1 Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Sample code to importing data from ODBC
- 14
- SSIS Capacity If your data have to be transformed, cleaned and this action of uploading is periodically i should use SSIS in any case. If you have a single file with 100 gb size i shouldn't use SSIS for that. if you have 100 gb of data in a file that can be bulk inserted in some columns of a table i should use bcp (before change recovery model in "Bulk logged" and after revert to initial recovery model of db) or T-SQL bulk insert command if yor data have not to be cleaned or transformed and in plus there is the effort to build a SSIS package. Tag: Sample code to importing data from ODBC
- 15
- Transaction log file disappearing without reason i don't think this is a problem of SQL Server. You cannot delete a log file of database which is in use from SQL Server. It may be the problem from OS or any other application. Madhu Tag: Sample code to importing data from ODBC
- 16
- Stored Proc NOT using Index? This could be as a result of parameter sniffing, SQL Servers attempt to provide an optimum query plan based upon values of parameters. Sometimes, this is not the "best" overall plan due to atypical values being passed in and therefore the cached plan for the stored procedure is less than optimal for the majority of queries causing poor performance. The code executes fast in SSMS as a new plan is generated on the fly. Read more here: http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx HTH! Tag: Sample code to importing data from ODBC
- 1
- Next
- 1
- Add column with fixed number of values (text) to the select statement I found on the net something to start with Adding Columns in SQL SELECT statements by Andy Kramek http://weblogs.foxite.com/andykramek/archive/2005/09/18/921.aspx SELECT *, CAST( 0 AS INT) AS newint FROM sample but it just add a column with value 0 to the set of results. Tag: Sample code to importing data from ODBC
- 2
- SQL 2005 - Migration from SQL2000 / LEFT OUTER JOIN Did you update statistics in all tables also AMB Tag: Sample code to importing data from ODBC
- 3
- Editing Input Data in Script Component Why don't you use a derived column instead Should be a better performing option anyway. [COLNAME] == " " "" : [COLNAME] Tag: Sample code to importing data from ODBC
- 4
- SQL Server Management Studio Express won't open but appears in task-bar If you have any databases that you care about, you can do a few things to rescue those and then manually uninstall and reinstall. If you don't care about the databases, just follow step number four in the first option. It may be that the system is OK and you're just having problems with the GUI loading, so try this first: 1. Check to make sure the SQL Server Services are running. 2. Open the sqlcmd command at the operating system and back up your databases (Look in Books Online for the "backup database" command syntax). 3. Put the backups in a safe location so that you can restore them later. 4. Uninstall SQL Server manually following this process: http://support.microsoft.com/kb/909967 5. And then reinstall SQL Server. 6. If this all works, you should be able to restore the database back to your system. You can read more about that in Books Online under the "restore database" command syntax. The next method of rescue might not save the databases if the system shut down incorrectly. 1. Ensure that the SQL Server services are shut down. 2. Locate the MDF files that belong to your database and copy them to a safe place. 3. Uninstall SQL Server manually following this process: http://support.microsoft.com/kb/909967 4. And then reinstall SQL Server Express. 5. If this all works, you should be able to "attach" the database back to your system. You can read more about that in Books Online under "attaching databases". It should be noted that this is a really strange event, and a simple crash wouldn't normally bonk the system like that. My suspicion is that something happened in the registry on the unclean shutdown. Buck Woody Tag: Sample code to importing data from ODBC
- 5
- Pass parameter to SSIS I would add a SSIS variable to the package to hold the parameter you want to pass, let's say @PassedParam. I would assign the parameter value via dtexec command line; using the SET option. I would put the SQL Statement into another SSIS variable that is based in a expression (EvaluateAsExpression property in the variable equal to TRUE). That expression would use look at the @PassedParam variable. Let me know if this make sense... Tag: Sample code to importing data from ODBC
- 6
- SQL Server 2005 Express Edition Yes. Tag: Sample code to importing data from ODBC
- 7
- Upgrading SQL Express: is it possible to restrict to which version upgrade is possible? No, not that I know. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Sample code to importing data from ODBC
- 8
- Partitioned Tables and Parameters Hi Eric, I guess you need to try creating an index. create clustered index idx_part on tblPartitionTest ( PartitionKey ) go regards Jag Tag: Sample code to importing data from ODBC
- 9
- Granting Permissions using SQL 2005 Schema... They would need alter schema to drop tables in the schema. GRANT ALTER ON SCHEMA::[Sandbox] TO [Sandbox Users] -Sue Tag: Sample code to importing data from ODBC
- 10
- replication folder's didn't locate local publications,need help! If you have installed MS SQL Server 2005 express edition, then you will not be able to see Local publications. You need MS SQL Server 2005 for this. Tag: Sample code to importing data from ODBC
- 11
- Returning a value that has the smallest number of instances in a table Something like this may work: Code Block SELECT * FROM ( SELECT TOP 1 AssessorRegistrationNo , COUNT (*) AS NoAssignments FROM MyTable WHERE Marked = 0 AND DateAssigned IS NOT NULL GROUP BY AssessorRegistrationNo ORDER BY COUNT (*) DESC ) AS Tbl HTH! Tag: Sample code to importing data from ODBC
- 12
- Error Casting String to Date I did something similar in thsi post http://rafael-salas.blogspot.com/2007/02/ssis-loop-through-files-in-date-range.html See if you can get any help from there. Tag: Sample code to importing data from ODBC
- 13
- Reporting Services Matrix Reports Repeating row labels Is it possible to repeat the row labels for matrix reports where there are multiple groups. So if the matrix report rows are department,division,employee then have all three labels show up on each row not just at the breaks. Cannot seem to find a way to do this. thanks Tag: Sample code to importing data from ODBC
- 14
- COUNT and COUNT_BIG are too slowly, what to do?! The reason for using count_big() is that you expect your returned count value exceeds INT limit. If your table is not that large there isn't a need for count_big(). The perf between using count() vs count_big() on this small table should be nearly identical. The first query should take the longest which is natural and expected. Later queries benefit from the first because the data has cached. It's absolutely wrong to correlate 1 second for 100K and 10 seconds for 1M. It does not work in such linear fashion. The length it takes to compute the count is all depending on the system at that time. If the system is busy and there is no cache, it can take forever. Tag: Sample code to importing data from ODBC
- 15
- LDAP vs ADSI parameter problem Part III Anybody there! :-( Tag: Sample code to importing data from ODBC
- 16
- Column Name select column_name,data_type from information_schema.columns where table_name='myTable' Tag: Sample code to importing data from ODBC
- 1
- Previous
Re: Sample code to importing data from ODBC
Jamie Thomson
Qiuwei wrote:
Hi, there;
I try to import data from ODBC using C# programmatically. Is there any sample code we can have a look. Like how to read schema from ODBC source table and then create source column...
Thanks
Sounds like you're in the wrong forum. If you are writing a dotnet app then try the dotnet forums.
If you are using SSIS then I'm not really understanding why you're writing C# code. Are you trying to build a SSIS package programatically using the SSIS API
-Jamie
Re: Sample code to importing data from ODBC
Qiuwei
Yes, I am.
The number of tables in ODBC source will change at any time. So I'd like to build SSIS package programatically using SSIS API. So what I want to do is to check to see if a table in ODBC source existing in SQL2005 first, if not, create a table first with same table name, schema... and then pump data.
Thank you.
Re: Sample code to importing data from ODBC
Jamie Thomson
Yes, I am.
The number of tables in ODBC source will change at any time. So I'd like to build SSIS package programatically using SSIS API. So what I want to do is to check to see if a table in ODBC source existing in SQL2005 first, if not, create a table first with same table name, schema... and then pump data.
Thank you.
Right, well this isn't a C# problem. Take C# out of the equation. How would you otherwise check to see if a table existed in your source
Note that this depends on what sourt of source system you are accessing and seeing as you haven't provided that information, I can't help you.
-Jamie