What Is Necessary To Create SDF-Files On Desktop Legally?
Nov 7, 2005I want to write a PC application that prepares a SQL Server Mobile Files (.SDF) and sends it to a PocketPC.
I get this error message:
ADVERTISEMENT
Need To Edit .sdf Files From Local Desktop
Mar 10, 2006I am needing to know if there is a way to edit .sdf files from my local desktop ( I need to copy the .sdf file to my local machine and edit the information if necessary)
Our mobile devices use SQL CE 2.0.
Thanks for your help
[Ask]Getting Files From Pocket Pc Emulator To Desktop Pc
Jun 8, 2006hi...!
I'm creating a small device application using visual studio.NET 2003. Is it possible to get a sql server ce database file (.sdf) that i created at the pocket pc emulator to my desktop pc ?
If that's possible, then can you tell me how to do that ??
thanx b4
Synchronize 2 Sdf Files On 2 Pdas With/without Desktop Application
Jun 10, 2007Hi All,
I am interested in synchronising 2 sdf files which are sitting on 2 different PDAs and I want to synchronise both of them with or without desktop application. C# applications are used to talk to the applications.
Is it possible or not and if possible how can i do that. Any code snippets or any links to similar forum posts or anything will be of great help. I am a C# programmer but not SQL Developer.
Regards
Trushar
Create A Mobile Database On Desktop
Jan 21, 2006I have searched through this forum and the news group
microsoft.public.sqlserver.ce
for this topic. I only find a post from Darren Shaffer and I requested a document.
Unfortunately, there is not a clear example of how to create a mobile database (sdf) on a desktop machine which contains VS 2005 and SQL server 2005 by using Visual Basic 2005.
I am sure a clear example in VB for this problem would help a lot of people. Hence anybody who knows how to perform this task, Please help these people.
Thanks in advance
Talat
How To Create A Database On MS SQL Server Desktop Engine
Nov 30, 2005Dear friends,
View 3 Replies View RelatedHow Do I Create A Database During Installation Of My C# Desktop Applicaton?
Nov 24, 2006Dear all,
I have developed a C# desktop application which uses SQL express as its database. It works just fine as I installed the application, used SQL express Server Management Studio CTP to create database with tables , stored procedures etc.
Now, I want to create an installer that will not only install my application to other machines but also create the database with all the tables and stored procedures with it.
How do I do so? I searched the answer in several places but none worked out for me. Can anyone please help me on this??
For your convenience I'm giving the following informations:
Database name: NorthPoleSQL sever Name: IshtiaqueSqlexpress (used Windows Authentication Mode)
I have detached the database from the original machine and have the NorthPole.mdf and NorthPole_Log.ldf files. I want to use these files and create the database in target machine rather than writing sql scrips and executing them.
Please help me with a descriptive, step by step instruction as I am new to this technology.
Thank you.
-Ishtiaque
Raw Files - Create Once
Feb 14, 2006Hi,
I try to add multiple files to a raw files. I use a loop for it and set the write option to "create once", so that the file should be created when the package is started and files are appended as they flow to the destination... However I always get an error when I try to add the second file that the raw file already exists... Well, I expect that it exists but I don't expect this error because that's not the intended behaviour!
Is there anything I also have to do to use the raw file as it's described in BOL?
Thanks,
Trying To Dynamically Create Text Files
Oct 27, 2006I need to get a list of customer ids and then use them as a parameter to select from a transaction table and then create a file for each customer. I have used an execute SQL task to get the list of customers and have put the result set into a variable.
How do go through the recordset to create a file for each customer?
How To Create Or Save Files In A Different Domain
May 16, 2007Hey,
I have an SSIS package that creates a new file and saves results into that file. However, the requirement has it that I need to create this file on a server residing in a different domain. How can I achieve this in an SSIS package when it is scheduled as a job?
Thanks,
Aravind
Show Files And Create Link To It .....
Jun 21, 2007Hi
I Need To Load Files From A Library Show Them In The Report
And After, TO be Able To Click On one Of These Files And See Them.
The File Types Are Jpeg, Gif, Doc, Txt....
Thanks
Roy
Create, Insert And Format Into 1,000 Excel Files
Feb 24, 2008Hello,
I need to create about 1,000 (literately) Excel files that each contain 5 tabs. The data being placed on the tabs will always be the same (meaning the columns are static).
I am fairly advanced at Excel VBA so I can write code that does all the following in Excel (looped 1,000 times):
Open an Excel template
Bring data in from the tables
Filter, then copy-paste the appropriate rows into each tab.
Save the new Excel file.
Email the file to appropriate individual (it is a Microsoft Exchange Server).
As I started this in VBA, I thought that I might be able to do it with SSIS. My concern is I need to have the rows formatted (font, border, etc.) and the number of rows change.
My questions are:
Is it possible to format Excel with SSIS?
Can I email the files even if it is not with an SMTP protocol?
Would SSIS process this data faster then Excel?
Does this approach even make sense? Am I better just doing it with VBA?
Thank you for the help.
-Gumbatman
SSIS Create Large Temp Files!!!
Oct 22, 2007
Hello,
I created a SSIS solution for reading data from dbase and storing them in SQL Server. In a ForEachDirectory-Loop up to one thousand dbase files are read and stored. The system where the packages are running has 16 GB RAM.
For the first few hundred dbase files everything goes fine, but then, the RAM seems not to suffice any more and a temp file is created (I changed the path in BufferTempStoragePath).
How can it be that there is a need to create temp files if there is so much RAM available?
Why is the RAM filled more and more during the SSIS package execution?
Is there anything I can do to release some of it? (it is running in a loop and there is no need to store all the data)
Could it be caused by dbase?? (I use Microsoft Jet 4.0 OLE DB Provider)
Another thing is that the temp file is not stored in the path I set in BufferTempStoragePath.
There are sufficient permissions set, but temp file is still created in user temp folder...
Any kind of help is very much appreciated!
Best Regards,
Stefan
T-SQL (SS2K8) :: Create Batch File To Selectively Run Files
Apr 24, 2014I have about 1200 sql files in one of my folders. Almost all of these files do data inserts and updates, so they should be run only once. As and when required I have manually ran around 150 of them already. Whenever I ran any of these scripts, I log that file name into a log table in my sql server including the execution time. Since running 1000+ more files takes a lot of time, I want to automate running of these files through a batch file. But I also want to filter the files that are already run.My file list looks like follows.
InsertToOrderTypes.sql
UpdateClientAddress.sql
DeleteDuplicateOrders.sql
InsertToEmailAddress.sql
ConsolidateBrokerData.sql
UpdateInventory.sql
EliminateInvalidOfficeLocations.sql
My log table in the database looks like this.
select * from sqlfileexecutionlog
FileNameRunTimeResult
---------------------
DeleteDuplicateOrders.sql03/12/2014 14:23:45:091Success
UpdateInventory.sql04/06/2014 08:44:17:176Success
Now I want to create a batch file to run the remaining files from my directory to my sql server. I also want to wrap each of these sql file executions in a transaction and log success/failure along with the runtime and filename into sqlfileexecutionlog table. As I add new sql files into this directory, I should be able to run the same batch file and execute only the sql files that have not bee run.
SQL 2012 :: Create Script That Will Import Large XML Files?
Jul 28, 2014I need to create script that will import large XML files (500 - 7GB) on a daily basis and store the data in a relational db structure.
What is the best and fastest way of importing such files. I have played around with smaller files and found the following.
1. SSIS XML Data Source: It doesn't seem to like the complex elements types and throws out the file.
2. Using Bulk File Import, sorting the file in XML variable and using XQuery to parse the file: This works but it can't take a file more than 2GB in size, so I can't use this method.
3. C# + XML Serialization: This also works, but seems to be terribly slow. I open the DB connection once, so it doesn't open and close for each db call, but still seems like it takes a long time.
how to import large XML quickly in a relational table structure?
SQL 2012 :: Cannot Create Extra Tempdb Files Because They Already Exits
Feb 23, 2015I was in the process of creating additional TempDB.ndf files, and received an error saying they already exist. I checked the location and it was empty, nothing to see here. So I looked in sys.master_files and there are several tempdb files listed in various locations, all of which come up empty.
So the files are listed as online in sys.master_files, but they do not exist on the server. I restarted SQL services but it did not change anything.
Create Alerts - Receive Notification About Dump Files
Jul 19, 2015I am working on creating a sql alerts. How to receive notification about dump files whenever they created in sql logs?
View 0 Replies View RelatedHow To Create Assembly Function Using Dll Files In SQL Server 2005???
Aug 21, 2007Hiiiiiiii all
I have to make a user defined function in c# as the class liberary and create a dll file, now i want to use this function in SQL Server 2005 as a part of CLR Integration
I have tried like this
CREATE ASSEMBLY abc
FROM 'C:abc.dll'
WITH PERMISSION_SET = SAFE
but it gives me
incorrect syntax error
so plzzzzz anyone help me wht to do in my probbbbbbbbb???????
Pratik Kansara
How To Create Dynamic Folder Which Contains All The Files Which Are Used By All The Packages In A Project
Mar 19, 2008Hi,
My Problem goes Like this....
I have a folder which contains all the flat files which are used by all the packages(ex--flat file connection managers) in my project.
If we want to change the name of the folder,have to change in every package( in all connection managers) manually.It looks hardcoding and timetaking.
Is there any way to change in one place(xml,file,variable) so that it should be affected in all the packages.
one more doubt is..
If we configure the flat file connection manager in package configurations,configuration file (ex-xml)will be created (we can make changes in that file regarding that connecion mgr only.)
But i want one configuration file (ex--xml) so that i should configure the details of all the connection managers used in all packages.
Error - Distribution Agent Failed To Create Temporary Files
Sep 17, 2014I've been using replication for a long while now but have never come across this error. It's a basic transactional replication from ServerA to ServerB, where ServerA is also the distributor. Everything had been running fine on it until yesterday, when this error started popping up and no further transactions could be delivered.
After some quick googling I was able to determine that the distribution agent account needed write access to C:Program FilesMicrosoft SQL Server100Com. According to the MSFT article it's because the distribution agent is running under a non-default profile. I didn't change this. However, what I did change around the time that these errors started occurring was the server's Replication Max Test Size setting. It would be far too coincidental for this to not be the cause, but what I don't understand is *why* that would have changed it.
how do I change this? It is definitely not preferable to create temp files in this directory in our environment.
T-SQL (SS2K8) :: Create Separate MS Excel Files By Looping Through Large Table
Jun 24, 2014I have a master table containing details of over 800000 surveys made up of approximately 400 distinct document names and versions. Each document can have as few as 10 questions but as many as 150. Each question represents one row.
My challenge is to create a separate spreadsheet for each of the 400 distinct document names and versions containing all the rows and columns present in the master table. The largest number of rows would be around 150 and therefore each spreadsheet will not be very big.
e.g. in my sample data below, i will need to create individual Excel files named as follows . . .
"Document1Version1.xlsx" containing all the column names and 6 rows for the 6 questions relating to Document 1 version 1
"Document1Version2.xlsx" containing all the column names and 8 rows for the 8 questions relating to Document 1 version 2
"Document2Version1.xlsx" containing all the column names and 4 rows for the 4 questions relating to Document 2 version 1
I assume that one of the first things is to create a lookup of the distinct document names and versions assign some variables and then use this lookup to loop through and sequentially filter the master table data ready for creating the individual Excel files.
--CREATE TEMP TABLE FOR EXAMPLE
IF OBJECT_ID('tempdb..#excelTest') IS NOT NULL DROP TABLE #excelTest
CREATE TABLE #excelTest (
[rowID] [nvarchar](10) NULL,
[docName] [nvarchar](50) NULL,
[Code] .....
--Output
rowIDdocNamedocVersionquestionblankField
1document11q1NULL
2document11q2NULL
3document11q3NULL
4document11q4NULL
5document11q5NULL
6document11q6NULL
[Code] .....
How To Create UNIX Format Files Using Flat File Connection Manager?
Dec 17, 2007Hi All,
How to create a text file in UNIX format using Flat File connection manager. By default when we create a connection manager for flat files it is taking "CRLF" as the delimeter.
I beleive the format of the file will be decided based on the control line feed character at the end of each row. There are different control line feeds for different operating systems.
CR - Mac OS (Carraige return)
LF - UNIX (Line Feed)
CRLF - Windows. (Carriage return Line Feed)
Correct me if i am wrong.
Thanks in advance.
ActiveX Script In A SSIS Package - Calling An FSO To Create/manipulate Files
Jul 3, 2007I have a SQL2000 DTS package that executes vbscript to loop through a recordset which:
- runs a stored procedure and populated tables
- builds a recordset from the populated tables to write records to an Excel file
- writes status to text files with either the error or success notices
I use FSO to set up the success and error files, but the scheduled job in SQL2005 which calls the SSIS package returns the following error:
"Retrieving the file name for a component failed with error code 0x0015F74C"
I can successullly run this (vbscript) in both the SSIS package via the BI Development Studio and in MS Access (exactly the same code in both) - but not as a SSIS package called in a scheduled job in SQL2005.
I am at an impasse with this ... any and ALL assistance would be GREATLY appreciated.
TIA,
Bob
Cannot Open / Create SQL Express Databases (.mdf Files) In Visual Studio 2005 Professional Edition
Sep 7, 2007Hi, I am trying to open or create a sqlexpress database within Visual Studio 2005 Professional in the App_Data folder. If I attempt either method, I get the following dialog box:Required Components MissingConnections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkID=49251 The link above just takes you to the download page for Sql Server Express 2005. I have both SQL Server 2005 Developer and SQL Server 2005 Expression instances running. The existing database will work properly in my web application, however I cannot access it through Visual Studio.As background, I did have a problem connecting to the database via the web application, receiving a "Failed to generate a User Instance of SQL Server" error. But I was able to fix that by renaming my SQLEXPRESS folder in C:Documents and SettingsuserLocal SettingsApplication DataMicrosoftMicrosoft SQL Server Data. When the web page ran, it created another SQLEXPRESS folder.However, I cannot figure out why I am having the other issue.Thanks in advancePatrick
View 1 Replies View RelatedSQL Desktop And C#
Sep 2, 2005Hello, i'm trying to make a c# web form in vs.net 2003 and a connection to a sql database.I'm using a sqlconnection control and a sqlcommand, but when i test it, the page said: "There was an error in login Encuesta, with the user LOCALHOST/ASPNET" (or something like that)i don't have the source code, and i am not in my pc, so, can somebody help me?
View 5 Replies View RelatedOLE DB On Desktop
Feb 28, 2007hello everybody,
I've installed SQL Compact Edition (with Visual Studio 2005) and i try to compile Northwindoledb for the DeskTop. The goal of this operation is to migrate a Pocket PC application (C++/OLE DB/SQL Mobile) to the desktop. If i can run properly Northwindoledb project i could start to migrate ...
I've the following error :
hr = pICmdText->Execute(NULL, IID_NULL, NULL, NULL, NULL);
GUID_NULL undefined
What can i do ?
Thanks in advance !
Desktop Server
Feb 24, 20071. Today I've installed webmatrix and MSDE200A and followed this instruction"Select 'SQL2kdesksp3.exe' and save it to your computer.Double-click on the SQL2kdesksp3.exe you downloaded.Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt.Start > Run > cmdNavigate to the directory you expanded the self extracting exe to and change to the MSDE subdirectory.The default is C:sql2ksp3Type Setup SAPWD=(Some password) SecurityMode=SQLExample:c:sql2ksp3> Setup SAPWD=password SecurityMode=SQLAfter that gets done running, MSDE is installed.Start servicesTo get the SQL Server running and the SQL Agent we need start the services.right click My Computer > manage > servicesDouble click the following and set to Automatic.MSSQLSERVERSQLSERVERAGENTMake sure both are on automatic." then I restarted my comp. I've tried to connect to database but it did not work.I need the reply ASAP!!!! 2.What are the different among MSDE200A.exe, sql2ksp3.exe, and sql2kdesksp3.exe ?
View 1 Replies View RelatedSQL Desktop License?
May 29, 2001If I just need a desktop version of SQL 7.0 installed for local development. (Not being used as a server) Do I just need a CAL license?
Thanks!
Can Not Connect To Desktop DB
Jun 28, 2001My organization supports both SQL 7 and SQL 2K. Therefore I have the Enterprise Manager
for SQL 2K on my desktop (it accesses both SQL 7 & SQL 2K, but the SQL 7 EM won't access
both).
I installed the SQL 7 desktop edition on my NT 4 (SP 6) workstation, but only the server (not
client connectivity or client tools).
When I attempt to perform a new server registration using EM (with the desktop server running),
I get the following message:
"SQL Server does not exist or access is denied"
I am attempting to logon as "sa" with a blank password since this will be my very first access of
the installed DB.
Startup of server specifies that the "local system" account be used. Server starts up fine as best
as I can tell.
For client connectivity I have both TCP and NAMED PIPES available.
Any help would be very much appreciated!!!!
Thanks Gary Andrews
andrews_gary_w@solarturbines.com
P.S.
Where blank passwords are used, do I enter a single space or not enter anything
and just press enter?
Desktop SQL Server 7
Dec 7, 1999Is it necessary to have a MS Loopback Adaptor to install SQL Server desptop edition at my home ? ( Otherwise i am unable to connect to the server from the EM )
Thanks,
Deepak.
Installing Sql 7.0 Desktop
Jul 26, 1999I have installed Sql 7.0 desktop edition on Win 98 with IE5 and am having a problem starting the Sql server.
It auto registered the server under my machine name. It was returning a network connection error so I deleted it and tried to add one with the name (local). Enterprise Manager then returned an error saying one was already registered under that name.
Anyideas?
Thanks
JC
Sql2005 For Desktop
Jun 1, 2007Hi All.
I have SQL2000 on my WinXP computer. Can I install SQL2005 on my desktop? If yes what version?
Thanks.
SQL 2000 Desktop
Jul 20, 2005Is it possible to install SQL 2000 desktop without installing a databaseserver? I need to have the interface to access my database servers, butdon't want the overhead of a server and the service on my laptop.Possible?ThanksDoug
View 2 Replies View Related