I had a small requirement i had a table with embedded attachments and attachments are uploaded to the table and saved in varbinary field from front end. Want i want is i want to download particular embedded files in that table within SQL Server itself. I have tried googling but none of seems to be within SQl Server T-SQL. all are linked to Asp.NET how i can do?
View 6 Replieswhat data type am i going to put to my uploadedFiles column in my database... uploaded files are in document format or .txt
also.. how can i make those files converted into pdf files.. also enable users to download it..
tnx!!!
forums.asp.net = "great help"
I have a package with an FTP task in the Control Flow. Nothing complicated, its configured to download a file from FTP with overwrite true, and the get and download paths in variables. Once this step completes it goes to a sequence container that does stuff with the file, that part works fine.
The problem is if i run the package in debug mode using Visual Studio, everything works perfectly (even if run over and over). The problem occurs if i use my "driver" application to try and execute the package. All my driver does is use C# code to create an Application object, set the PackagePassword, LoadPackage based on the path and then .Execute().
Here is when the strangeness begins:. If the file exists in the destination path, then the FTP task fires. If the file does not exist (lets say i manually delete it after its being downloaded before using the IDE) the FTP task dose not fire and my Sequence Container fails to use the fail, since it is of course missing.
Monitoring the FTP server that i am running locally i can see commands firing when the file exists, but when the file is killed it never even tries to connect to my server. Very odd.
Am i missing something? Why would this work from the IDE but never from my driver?
Any help would be appreciated. Please let me know if any additional detail is required.
Dmitry
http://blog.lyalin.com
Hi,
I'm trying to work on a database when I'm not connected. I can't figure out how to get a local copy of a database.mdf that I created on the server, onto my hard drive, using SQL Management Studio Express. Does anyone have any suggestions? I'd be forever in your debt. Thanks
I have the misfortune of converting a DTS package to SSIS that loads a flat file that has a text fields that can contain embedded text delimiters ("), column delimiters (,) and even new lines (CR+LF i.e.,hex 0D 0A) in it. A sample line from the file is posted here, remember this is just one line though it shows as three lines, since the third field has embedded new line in it:
4,"Sam","EVP; MARKETING PRODUCT MANAGER ""Level I"",
Internet Sales / HELP
8005551212",100
If you open in excel it handles it perfectly showing four fields, as below, and this is what I want ( I cannot get it aligned right in the posting, just save the above line in *.csv and open to see what it should be):
4 Sam "EVP; MARKETING PRODUCT MANAGER ""Level I"", 100
Internet Sales / HELP
8005551212"
Now, SSIS errors on the embedded text delimiters and breaks into two or three lines based on which option I chose. I have tried few options based on postings in the forum:
a). Using undouble and undoubleout: Does not work when there are embedded column delimiters (,) in the text field
b). Modified undouble script posted by lvovg at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1718225&SiteID=1. Handles the embedded column delimiters (,) perfectly, but the embedded new lines (CR+LF i.e.,hex 0D 0A) are breaking it.
Since, I am using the ragged right format to read from the file then use transform script on the line by lvovg, the line is already broken by the ragged right format at the embedded new lines, hence does not work.
Right now I am stuck. Can someone please help (anyone from MS) ? I am already baffled at the amount of coding required to convert a very basic ( and working ) flat file load DTS package to SSIS. I am willing to persist bit longer to convert this to SSIS, before I give up and stick with DTS and wait for a fix / workaround.
Thanks.
Hi Mates,
I am unable to fetch data from Source which is CSV file whose sample contents are given below:
-----------------------------------------------------------------------------------------------------------
"Fiscal year";"Posting period";"Company Code";"Functional area";"Profit Center";"Business area";"Group Account";"Posting Level";"Document Type";"Accounting Principle";"Cost Pool";"Financial Owner";"Period Value GC"
"2006";"12";"AR00";"A107";"P1131";"7200";"3410";"10";"18";"GAAP";"#";"#";"$ 0.00"
"2006";"12";"AR00";"A107";"P1131";"9600";"3410";"10";"18";"GAAP";"#";"#";"$ 0.00"
--------------------------------------------------------------------------------------------------------------
The error message that comes while I preview the source data:
Error:
"The Preview sample contains embedded text qualifiers. The flat file parser doesnot support embedding text qualifiers in data. Parsing columns that contain data with text qualifiers will fail at runtime"
Is there any alternative to remove these text qualifiers from the file. Do we have any utility that can convert these files into text qualifier free CSV file?
I have the following SQL
IFOBJECT_ID('tempdb..#TempTable_Lockbox_File_Header_Record')IS NOTNULLDROP TABLE#TempTable_Lockbox_File_Header_Record
;
IFOBJECT_ID('tempdb..#TempTable_Lockbox_Batch_Header_Record')IS NOTNULLDROP TABLE#TempTable_Lockbox_Batch_Header_Record
;
[code]....
When I send my query results to a file in SQL Server Management Studio, how come I'm seeing the following in Notepad++? FHÂ Â TEST "FH" which I thought should be in a CHAR(2) data column is there but "TEST" seems to start in Column 6...not column 3 as I would have expected. I was expecting... FHTEST.
I am looking for some material for downloading documents from sql
server. I can upload documents in my app but i would also like to
download those files too.
Thank you
I keep getting eeror mess when downloading SQL server 2005. Micro soft cust service says they are not qualified to fix but if I pay $99.00 they can have someone help with it.
I think that is nuts since they are sending me the download. I tried to do it manually and some components installed but everyday I get update notifications
HELP! PLEASE!
Our entire sales database sits on an Informix server and users run their reports directly to this server.
Because of the volume of data - upwards of 7 million rows in some tables we are finding performance is becoming an issue. We realise that Informix is not the best for running queries and so are looking to replicate to a SQL server and use that as a reporting server.
My chosen method is DTS using ODBC which works fine. However due to the sheer volume of data to be downloaded each night (over a 512K wan link) we only want to download changed data.
Is there any way we can get SQL2000 to download only change data - i.e a differential download or something? We don't have a unique field in the table (for whatever reason) such as sales date or transaction ID (shops might upload old / back-dated transactions for example due to a systems failure).
If I do have to download all the data every night is my method the most efficient or is there some other approach I could use?
Ultimatly the aim here is to relieve the Informix server of the reporting overhead so any alternative ideas are welcome!
Many thanks
Hello World,
I am trying to download the SQL Express Server 2005 software direct from Microsoft. I am having trouble locating the ENGLISH version. I am located in Frane but prefer using software in my native language....no pun intended. Every attempt to d/l gives me the French version. Can anyone provide me a link for the ENU version of SQL Express Server 2005.
Thank You in Advance,
Best Regards,
Richard J. Rothery Jr.
rjstinyc@hotmail.fr
Hello,
I have a problem downloading Microsoft SQL Server 2005 Express Edition with Advanced Services.
Every time I download the complete file (234 mb) I get an error that the downloaded file is corrupt. I've tried also downloading it on other locations but every time the file is corrupt.
Is there another way to obtain this version of SQL server 2005 ?
I'm looking for a sample Database that is well set up to learn from. Does anyone know where I can download one from?
View 1 Replies View RelatedI everybody,
I'm trying to download Microsoft SQL Server Management Studio Express from
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
However, the download never finishs.
If I try to download using a download manager it stops after 98% (the segment that stops is the first segment).
If I try to download without a download manager it stops after 1% (456Kb).
What can I do?
Is there an alternate place where I can download the file?
Thanks,
Nadav
I was wondering if anyone had tried to embed sql server express in a .net application. Specifically, I want to use it from within the app only, similar to embedded mysql (libmysqld) or firebird. I've seen some articles on sql server express saying this can be done, however there is no info on how do to this. Anyone know how it might be done?
View 1 Replies View RelatedI am working on SQL Server 2008 and there is a problem in my SQL Server log file. I am seeing this from last 8 days, my log file size increasing continuously while i have set it on Simple Recovery model. Is there any method from which I can reduce the size of my log file and also I want to know, how the Recovery models affect to the size of a log file?
View 4 Replies View RelatedHi,my problem is the following
I can not completely understand how to deploy sse with my application
To some degree I understand the explaning in Mikes Documentation
Things I don't get:
1)Do I not check the prerequisite server express because when I did and run the setup.exe that I build the thing that happens is that the sql package gets unpacked over and over along with a little message that it's taking a little longer then expected. I gues this is the fallpit where the actual setup.exe for sse is nothing being done with hence the wrapper.
A quote from Mikes document "If the VS Bootstrapper isn't flexible enough for you then". Well, I don't know what I'am doing wrong but it doesn't work at all. I had no problem with the other prerequisites (Framework, installer)
Back to the first question: if so do I manually add the SQLEXP.EXE (downloaded from the internet) or is it the sqlexpr32.exe in the same folder as the setup.exe for the application?
2) How is the wrapper invoked? I don't see that mentioned. I thought when you start the application itself, but that hardly seems logical.
Please anyone, give me some clear directions or additional expanatory
Thanks,
Richard
What is the feature Matrix for the recent SQL Server 2005 for SBS update? I specificly had the update installed to get SQL Server 2005 and utilize the new Database Mail, and the CLR functions. Where is it that it says.. btw, no Database Mail for you SBS chump!... Oh.. and well, you have to buy a new server and a full license of SQL Server 2005 to access smtp and send html email. I'm a little irrate about this, I advocate for MS technology every day and don't like getting bit in the *** reading SQL Server 2005 marketing materials and then recieving its retarded cousin for my SBS server. Hey,, charge me a little more money. Just put in a reasonable feature set. So, as far as can tell so far. No CLR coding and no Database mail, its like the body with no arms and no legs, but a better heart, pumping blood to nowhere.
Someone please tell me I'm ignorant and lazy and point me to how I can get these features working with investing 10,000 for a simple html email trigger.
I need to store file(s) to SQL without streaming / reading at Server. I have created a Web API with AngularJS and SQL. e.g.Â
var fileType = httpRequest.Files[file].ContentType;
    var fileStrm = httpRequest.Files[file].InputStream;
    var fileSize = httpRequest.Files[file].ContentLength;
    byte[] fileRcrd = new byte[fileSize];
    var file_Name = Path.GetFileName(filePath);
    fileStrm.Read(fileRcrd, 0, fileSize);
Is it possible to send file data to SQL (in bytes) without streaming / reading at server?I don't want to put a load on server for large files. just read  the data and send them to SQL where SQL will do the streaming and store data as varbinary.
Is it ok to use SQL Server 2005 CE as an embedded DBMS inside a desktop (Windows XP / w2k3 / Vista) application?
The whitepaper available here: http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc describes this as one of the primary usages of the product. However, I've seen information elsewhere on this forum that seems to imply that SQL Server 2005 CE is not allowed in desktop applications.
Can you please clarify this, and specify any limitations of this usage?
Also, the whitepaper refers to an online redistribution agreement that needs to be signed in order to freely redistribute SQL Server 2005 CE inside a commercial application. Can you please point to this agreement?
Thanks,
IonWarp
Hello All,
Can someone tell me the actual significance of SQL Server Embedded Edition? How is it different from SQL Express edition?
I understood that WSUS 3.0 version uses (installs) the latter when it could not find any SQL 2k or SQL 2k5 other than SP1 release (please see Issue 33 in: http://technet2.microsoft.com/WindowsServer/en/library/94d1385f-4872-4c29-8822-3a4ec5e45ae41033.mspx?mfr=true) on the host machine.
Besides, when i installed WSS v30 release version, i saw this instance being installed (during the configuration of the Sharepoint products and technologies wizard just after the installation is done). Now with this instance installed, i tried opening this instance (instance name being Microsoft#SSEE) through SQL Server Management Studio, i get the following error
"TITLE: Connect to Server
------------------------------
Cannot connect to BANAPPS01MICROSOFT##SSEE.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
"
Please let me know if there's any workaround in getting through this database.
Since i'm not able to open this database, i'm not quite sure if the Sharepoint Central Administration tool is adding the content DBs in the same.
PS: I'm able to create the new webapplication using the Central Administration tool but not able to access the site created. I'm getting site not found errors.
I followed the KB article mentioned in http://support.microsoft.com/default.aspx?scid=kb;en-us;914277, but in vain.
This is what i have in my System:
MS SQL SERVER 2k5 (Release version)+SP1
MS VS 2k5, Developer Edition
Windows 2k3 Standard + SP1
Office 12 beta (I dont think this is an issue as i got the same issue even after uninstalling office12 beta version)
I must import some exemplary file to database (MS Srrver 2000) ofcourseusing procedure Transact SQL.This file must:1.Read the xml file2. Create table3. Import this date from xml file to my databasePs. I create procedure who File xml imports to base, but unfortunately sheonly schedule when earlier create a table or table is created.So I need (Ithink) create such mini parser in language transact SQL.Does someone have some ideas?For every help Thanks==== example file xml ===========================================<root><Cust><IDosoby>1</IDosoby><Imie>Lukasz</Imie><Nazwisko>Przypadek</Nazwisko></Cust><Cust><IDosoby>2</IDosoby><Imie>Dariusz </Imie><Nazwisko>Mroz</Nazwisko></Cust><Cust><IDosoby>3</IDosoby><Imie>Tomasz</Imie><Nazwisko>Kolo</Nazwisko></Cust></root>================================================== =========--Luk
View 3 Replies View Related
Hello all,
I€™m looking for some help to get my Windows SharePoint Services 3.0 back on-line running without losing the documents stored on it..
Configuration basics: Microsoft Windows SharePoint Services 3.0 on member Server 2003 Std w/ SP2 using the Windows Internal Database (MS SQL Server 2005 Embedded Edition)
I had the SharePoint Services site operating on a member server.
I used the Manager the Server wizard to Install Active Directory on the member server. (Ouch! My Mistake)
I broke the SQL Server 2005 Embedded Edition Service. It would not restart. The System Evt code was 7024 error 3417.
I researched and found KB 929665 which describes my symptoms perfectly.
http://support.microsoft.com/kb/929665
I tried the recommended command (see Note1) and the configuration failed.
I discovered the following errors in the log file:
GetServiceUserGroup failed for MICROSOFT##SSEE, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No mapping between account names and security IDs was done.
Source File Name: sqlcasqlcax.cpp
Compiler Timestamp: Mon Feb 27 02:04:14 2006
Function Name: SetInstanceProperty
Source Line Number: 1223
Error Code: 1332
MSI (s) (2C!4C) [19:08:50:678]: Product: Microsoft SQL Server 2005 Embedded Edition (Windows) -- Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
<Failure Type='Fatal' Error='1332'>
<EndFunc Name='LaunchFunction' Return='1332' GetLastError='0'>
Action ended 19:08:50: SetInstanceProperty.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
Action ended 19:08:50: INSTALL. Return value 3.
Note 1: Msiexec <MSI_File_Name> CALLERID=OCSetup.exe REINSTALL=ALL REINSTALLMODE=omus /qn REBOOT=ReallySupress /l*v <Log_File_Path>
(Note: the line is missing the switch €œ/i€? after MSIEXEC)
How can a get my SharePoint working again?
Thank you!
Mike
Good Afternoon.
I am trying to write a short application within which I would like to embed a SQL Server Express database, all of which would be deployed via ClickOnce through a web site. The installation process seems to be working without trouble, including installation of the .NET Framework 2.0 and SQL Server Express 2005.
When the application launches on the new machine, however, I get a big Microsoft .NET Framework "Unhandled exception" error dialog box that indicates the database already exists and that the database file could not be attached. I am working with a clean virtual machine that I know has never had the database installed on it.
I fear I am overlooking something quite straightforward, but since this is the first time I have ever attempted to build a data-bound application, I am not sure where I am going wrong.
Perhaps the source of the problem, or a related problem, might be revealed even when I run the application in debug mode from within Visual Studio. I can run the application once, but if I try to run it again, I get an error when I try to open the database connection that is similar in content (database already exists...could not attach). I can run the SSEUtil and detach the database and then run the application again in debug mode and it works no problem (the first time!).
Lastly, if I install the application on the machine on which it was developed and make sure the database is detached, it will run without any trouble (even repeatedly). But, on a new blank machine, there is no database listed that matches my database name, so I cannot try to detach anything!?
My apologies for such a novice question!
Sean
I am trying to use Integration Services for something I've never done before; i.e., download a few files from an AS 400 and then turn around an email them to a user.
My basic problem is that I don't know where to start to get the files from the AS400 to a directory on the SQL Server. I have an Iseries ODBC connection configured correctly that will let me get to the files. Do I use a file system task to get the files from the AS 400 or do I use a data flow task? Don't know what task to start with. Once I get the files into a directory on the SQL server I don't think I will have any trouble emailing them.
I know it's a silly question but I've looked at a couple of books without any obvious answer popping out.
Steve Wells
In my SSIS Package, I have to write my [FileHeaderRecord] row, then my [BatchHeaderRecord] row, then my details. How can I do this in a SQL Server Query? When I try my SSIS, my file looks like so..
FHTEST 00000208262015Â Â Â Â Â Â Â Â Â Â Â Â BH000208262015Â Â
I want my BH, Batch Header data, to appear on a new row in the file.Do I have to build a dynamic query to do this?Is there any trick in SSIS to do something like this?I did try creating separate Data Flow Tasks to Query the [FileHeaderRecord] and then use a Flat File Destination and then another Data Flow Task to Query the [BatchHeaderRecord] and use a Flat File Destination again NOT overwriting the file.
hi all
i have the 2000 adition but i realy want the 7 version
and now microsoft offer as a shareware only the new 2000 to download as a limited pack
my questune is whare can i get the 7 version on the internet as a shareware
time trail or whatever
thanks in advance
I've been experienceing probelms downloading any of the visual studio express tools. I keep getting a site not available error and/or the vwsetup.exe crashes.
Do you have a better place for me to post for this issue?
I'm running Vista Home Premium 32-bit on a AMD Turion64x2 Mobile
Please help!
Dear All,
I am new to SQL I download "sql2ksp3" to my laptop (Window Xp Pentium III) and then I start to setup MSDE:
>> setup SAPWD=pass SECURITYMODE=SQL
After I run this command it gives me the following statment!!!
Setup failed to configure the server.Refer to the server error logs and setup error logs for more information.
Please help me what i have to do to make this stuff works!!
Sincerely
Henok
Hi,
I want to download data to excel in which each filename varies depending on the day i download them.
Ex.
ExportFile_09272007.xls
Can this be possible?
cherriesh
Hi
This is to do with HTTPS merge replication. We were getting an error when downloading the initial snapshot. The snapshot was about 25 meg, over an average link. It returned an error after a few minutes - it did start to download the .cab file (it was compressed).
By not compressing the cabinet file, it worked fine - I can only presume it was some sort of timeout error. The downside was that the amount of data was much greater, with it not being compressed.
Questions therefore are:
a) is this time of timeout a known condition and if so what can I do about it
b) slightly unrelated- can an alternate location be given for the snapshot, like you can in non-HTTPS anonymous subscriptions.
Main properties in creating the subscription is as follows:
subscription.InternetUrl = webSyncUrl
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication
subscription.SubscriberType = MergeSubscriberType.Anonymous
subscription.SyncType = SubscriptionSyncType.None
and when synchronising....
subscription = New MergePullSubscription()
agent = subscription.SynchronizationAgent
agent.PublisherSecurityMode = SecurityMode.Standard
agent.DistributorSecurityMode = SecurityMode.Standard
agent.UseWebSynchronization = True
agent.InternetSecurityMode = SecurityMode.Standard
Thanks
Bruce
hi guys,
i want to use SSIS package to download files from an http website.
i am tried using Http connection managers and webservice task but it asking me the wsdl file. i dont know where that file is.
can anyone please guide me? or suggest me any other way to do this?
I can not download sql express 2005 from microsoft website. Everytime I click on the download button I get error saying "this page can not be displayed. Possible reason... internet connection" I know my internet connection is working because I am browsing through the microsoft website and other websites. I had .net 1.0 in my computer so I unintalled that to try to intall the latest 3.0 version but when I click to download that I get the same error. Seems I can not download anything from microsoft website. I uninstalled windows intaller and automatic update downloaded latest version of windows installer. When I tried to download windows installer from microsoft website I got the same error.
I am using Windows XP home edition version 5.1 sp2.
Please help!!
Thank you,
Jay