December 24, 2013 at 7:00 am
Hi,
I am running a POC database on my desktop using SQL Server Express 2012. I have created some triggers that work when I manually run a DML statement but do not seem to run when I use the Import Query. Is it possible to run a trigger based on Import?
Thanks,
J
December 30, 2013 at 11:38 am
bump
December 30, 2013 at 12:13 pm
jeandlauro (12/24/2013)
Hi,I am running a POC database on my desktop using SQL Server Express 2012. I have created some triggers that work when I manually run a DML statement but do not seem to run when I use the Import Query. Is it possible to run a trigger based on Import?
Thanks,
J
When you say you are using an Import Query, what exactly are you using?
December 31, 2013 at 8:57 am
SSMS. I am new to SQL Server. Is there better software to do this?
December 31, 2013 at 9:46 am
I believe that Lynn was referring to what command did you use (eg. INSERT INTO, BULK INSERT, bcp, etc).
December 31, 2013 at 10:16 am
I'm using the SQL Server Import and Export Wizard.
Is there a way to write SQL to import from Excel using SS Express?
December 31, 2013 at 10:38 am
jeandlauro (12/31/2013)
I'm using the SQL Server Import and Export Wizard.Is there a way to write SQL to import from Excel using SS Express?
The import/export wizard uses SSIS behind the scenes. SSIS does not fire triggers unless configured to do so. If I remember correctly the import/export wizard does not provide a means to set the package to fire triggers. You would have to save the package and then edit it using BIDS.
December 31, 2013 at 11:54 am
Thank you!
I am trying to use Bulk insert query instead.
December 31, 2013 at 12:04 pm
Remember to use the option to enable triggers (FIRE_TRIGGERS) or the result will be the same.
December 31, 2013 at 1:16 pm
actually I've spent a lot of hours looking for a solution to query xls from SSMS. In MS Access you can link xls. In Excel you can link just about anything very easily. Why is it so complicated with SQL Express?
December 31, 2013 at 1:46 pm
Because you are now working with SQL Server, not a desktop application.
January 6, 2014 at 12:34 pm
I just mean I thought it would be easier to link Microsoft data tools together.
January 6, 2014 at 12:54 pm
Okay, you are missing the point. Even though SQL Server Express can be used as a Desktop database system, it is a full blown RDBM system. It is the same engine used by the Standard and Enterprise editions of SQL Server, just not all of the functionality is available, just as not all features are available in the Standard Edition that are available in the Enterprise Edition. The type of integration you see within the Microsoft Office applications is not a part of SQL Server.
January 6, 2014 at 12:56 pm
jeandlauro (1/6/2014)
I just mean I thought it would be easier to link Microsoft data tools together.
I've been wondering the same thing for years (almost 2 decades, now). When I've asked about it, their answer is to use SSIS... I don't care for that particular application but I've stopped asking "why" about things like this.
--Jeff Moden
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply