Plowmister
asked on
Exporting / Importing from/to SQL Express ! Urgent!!
Hi,
I need to know the functionality of SQL Express in relation to working with exports and imports of custom file formats (delimited).
I found a lot of mentions to DTS but this is not part of SQL express...
Is there a programmatic way to execute these functions...?
I think the import might work with a bulk insert but what is the equivalent for the export?
Regards,
Plowmister.
I need to know the functionality of SQL Express in relation to working with exports and imports of custom file formats (delimited).
I found a lot of mentions to DTS but this is not part of SQL express...
Is there a programmatic way to execute these functions...?
I think the import might work with a bulk insert but what is the equivalent for the export?
Regards,
Plowmister.
ASKER
I will check it out...Thanks I didn't realise this was available....
Plowmister...
Plowmister...
ASKER
Hi,
I installed both the Toolkit one and the Adv Features one but still don't know how to use/access the DTS???
Any idea?
Plowmister.
I installed both the Toolkit one and the Adv Features one but still don't know how to use/access the DTS???
Any idea?
Plowmister.
Unfortunately, neither DTS (which belongs to SQL Server 2000) or its new incarnation SSIS (SQL Server Integration Services ) is avaliable to SQL Sever Express you will have to upgrade to the full version.
ASKER
So, in respect to my problem....can someone help with using a filesystem object (e.g. data123456.txt) and appending query data in to it?
I'm not really in a position to fork out a few thou for the added bonus of exporting data in the easier DTS way...there must be a programmatic way surely?
Plowmister.
I'm not really in a position to fork out a few thou for the added bonus of exporting data in the easier DTS way...there must be a programmatic way surely?
Plowmister.
>>can someone help with using a filesystem object <<
What is your front-end language, VB, .NET, Java, Delphi?
What is your front-end language, VB, .NET, Java, Delphi?
ASKER
I use VB, ASP...
but is there a T-SQL procedure for accessing/creating (I/O) files?
Plowmister...
but is there a T-SQL procedure for accessing/creating (I/O) files?
Plowmister...
>>but is there a T-SQL procedure for accessing/creating (I/O) files?<<
No there is no T-SQL syntax for handling files. However, since you are using SQL Server 2005 you should be able to access the .NET CLR to open files.
No there is no T-SQL syntax for handling files. However, since you are using SQL Server 2005 you should be able to access the .NET CLR to open files.
>>>is avaliable to SQL Sever Express you will have to upgrade to the full version
that is not entirely true, i downloaded the sql server business intelligence studio as per above
and yes i ported my sql 2000 dts packages to the sql 2005 since they wouldn't run after updating my 2K db
i run these express tools because i have no access to the full version :)
that is not entirely true, i downloaded the sql server business intelligence studio as per above
and yes i ported my sql 2000 dts packages to the sql 2005 since they wouldn't run after updating my 2K db
i run these express tools because i have no access to the full version :)
----------
Microsoft SQL Server 2005 Express Edition Toolkit (more...)
SQL Server Express Toolkit provides tools and resources to manage Microsoft SQL Server 2005 Express Edition, and to create reports by using SQL Server 2005 Reporting Services. The kit includes Connectivity Components, Business Intelligence Development Studio, Management Studio Express, and a Software Development Kit. To create reports by using Reporting Services, you must use Business Intelligence Development Studio.
----------
not sure why you can't access what i can, but i did a complete install with all the whistles and bells so also the sample db's for reporting services and other stuff
Microsoft SQL Server 2005 Express Edition Toolkit (more...)
SQL Server Express Toolkit provides tools and resources to manage Microsoft SQL Server 2005 Express Edition, and to create reports by using SQL Server 2005 Reporting Services. The kit includes Connectivity Components, Business Intelligence Development Studio, Management Studio Express, and a Software Development Kit. To create reports by using Reporting Services, you must use Business Intelligence Development Studio.
----------
not sure why you can't access what i can, but i did a complete install with all the whistles and bells so also the sample db's for reporting services and other stuff
bruintje,
>>downloaded the sql server business intelligence studio as per above<<
When you download and install the tools to SQL Server Express you should have got the following message at the end:
<quote>
Business Intelligence Development Tools for Integration Services and Analysis Services
The version of Business Intelligence Development Tools that is included in SQL Server 2005 Express Edition Toolkit does not include projects for SQL Server 2005 Integration Services or SQL Server 2005 Analysis Services. These projects are available only with editions of SQL Server 2005 that include Integration Services and Analysis Services. SQL Server 2005 Express Edition does not include Integration Services or Analysis Services.
SQL Server 2005 Express Edition and Express Edition with Advanced Services
To download SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services, see the SQL Server Development Center on MSDN (<http://go.microsoft.com/fwlink/?linkid=51793>).
Documentation and Samples
To install SQL Server 2005 Books Online, download them from the SQL Server Developer Center on MSDN (http://go.microsoft.com/fwlink/?linkid=51793).
</quote>
If you are saying that despite that you managed to install Integration Services on SQL Server Express, all I can say is more power to you and congratulations.
>>downloaded the sql server business intelligence studio as per above<<
When you download and install the tools to SQL Server Express you should have got the following message at the end:
<quote>
Business Intelligence Development Tools for Integration Services and Analysis Services
The version of Business Intelligence Development Tools that is included in SQL Server 2005 Express Edition Toolkit does not include projects for SQL Server 2005 Integration Services or SQL Server 2005 Analysis Services. These projects are available only with editions of SQL Server 2005 that include Integration Services and Analysis Services. SQL Server 2005 Express Edition does not include Integration Services or Analysis Services.
SQL Server 2005 Express Edition and Express Edition with Advanced Services
To download SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services, see the SQL Server Development Center on MSDN (<http://go.microsoft.com/fwlink/?linkid=51793>).
Documentation and Samples
To install SQL Server 2005 Books Online, download them from the SQL Server Developer Center on MSDN (http://go.microsoft.com/fwlink/?linkid=51793).
</quote>
If you are saying that despite that you managed to install Integration Services on SQL Server Express, all I can say is more power to you and congratulations.
Thanks for you clarification, but i thought this question was related to DTS and DTS comes with "The version of Business Intelligence Development Tools that is included in SQL Server 2005 Express Edition Toolkit "
at least i was able to port my existing SQL 2000 DTS package to the SQL Express version
if i mistakenly thought this question was related to DTS in SQL Express then i've made a mistake
for other functionality haven't looked, because i don't need it :)
at least i was able to port my existing SQL 2000 DTS package to the SQL Express version
if i mistakenly thought this question was related to DTS in SQL Express then i've made a mistake
for other functionality haven't looked, because i don't need it :)
>> DTS comes with "The version of Business Intelligence Development Tools that is included in SQL Server 2005 Express Edition Toolkit "<<
You learn something new everyday at EE.
You learn something new everyday at EE.
@acperkins, you're good ;-)
went back to my machine trying to determine what version it really was, the only real proof was the db size [17.5 GB]
forgot i already decided to install the msdn 2005 full version instead of SQL Express which was really my intention but because its limited to 4GB i chose for the full version
sorry for my mistake so i guess DTS is not in the express version and also not in the downloads on the Microsoft site
i'm an idiot :)
went back to my machine trying to determine what version it really was, the only real proof was the db size [17.5 GB]
forgot i already decided to install the msdn 2005 full version instead of SQL Express which was really my intention but because its limited to 4GB i chose for the full version
sorry for my mistake so i guess DTS is not in the express version and also not in the downloads on the Microsoft site
i'm an idiot :)
ASKER
The Quest Continues...
...I did try to to use BCP to some extent it did part of what I was looking for (data export) but no great flexibility with formatting...so it's the BCP wordwrap method or nothing at the mo...
...I did try to to use BCP to some extent it did part of what I was looking for (data export) but no great flexibility with formatting...so it's the BCP wordwrap method or nothing at the mo...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
DTS is part of SQL Express its in SQL Server Business Intelligence Studio that replaces the previous version DTS wizard
its part of Microsoft SQL Server 2005 Express Edition Toolkit
source: http://msdn.microsoft.com/vstudio/express/sql/download/
hope this helps a bit
bruintje