File System Watcher can not read excel from SharePoint

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - Multi-user access through a data-access layer/remoting server Hi Jeff, Thanks for the response. I'm not sure if the link you suggested is what I'm trying to do since I'm not using ASP.Net at all. SSCE is a single-user database. So I'm trying to find out if its feasible to have the Remoting Server (RS) as this Single-User. This RS would contain all the data-access remoting objects which would use ADO.NET to talk to SQL CE DB. The Client users would then connect to this RS through tcp or http and the RS would handle the connections to the SQL CE and pass the data back to the Clients. (And better yet, a layer of .NET Serviced Components between the RS and DB could provide all the services such as JIT, Object Pooling etc.) As far as the SQL CE is concerned, all the calls are coming from the same app (RS) from the same machine. If you are going to the trouble of implementing what you suggest, then why not use SQL Server Express and have full upgradeability to SQL Server I've already got an hosted architecture which uses SQL Standard and the other layers I'm talking about..however all the CRUD operations are coded in Stored Procs and Views. Now, I want to scale down this model to a web-downloadable app with zero support assitance for server set-up etc. for a max of 10-20 Concurrent users. I was thinking about SQL Express, but the biggest red flag in that are A) the inability to hide the database design ( completeley unacceptable because of the security concerns and proprietary nature of database design) and B) size of the download plus the complex installation and maintenance. So my ONLY option to get close to the flexiblity of an Access DB is SQL CE. But as you mentioned, there are huge costs to pay such as getting rid of the stored procs, views, and limiting the data types, no check constraints However, the pros seem to outweigh the cons for now. Please let me know if you have some other links, resources or suggestions. Regards, CP Tag: File System Watcher can not read excel from SharePoint
  - 2
    - How To Connect From SQL Server Database To Another SQL Server Database Hi, Follow these steps: 1. Link the Server B to Server A. Use the sp_addlinkedserver 2. Try this query then select * from [ServerB].[dbname].[dbo].[test] HTH, Suprotim Agarwal ----- http://www.dotnetcurry.com ----- Tag: File System Watcher can not read excel from SharePoint
  - 3
    - How to create Vertical Partioning The link is not working!! Tag: File System Watcher can not read excel from SharePoint
  - 4
    - xp_smtp_sendmail Please do not multipost: Answered in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1412270&SiteID=1 Tag: File System Watcher can not read excel from SharePoint
  - 5
    - Error Message Text in Multi Languages I agree with chris. cursor is very slow for this. --good data SELECT PhoneNumber FROM @PhoneNumber WHERE PhoneNumber NOT LIKE '%[A-Z]%' -bad data SELECT PhoneNumber,'english error', 'other language error' FROM @PhoneNumber WHERE PhoneNumber LIKE '%[A-Z]%' Tag: File System Watcher can not read excel from SharePoint
  - 6
    - Copy Folders and Files to different location I have a situation from where I need to loop through different folders and files in these folders. After processing these files, I need to archive these folders to different location. e.g., C:\MainFolder\Mar01 ==> Multiple files in Mar01 folder C:\MainFolder\Mar02 ==> Multiple files in Mar02 folder Does any one know the best way to do this in SSIS Thanks in advance. BC Tag: File System Watcher can not read excel from SharePoint
  - 7
    - Permissions to view Stored Procedure Property I have done that for the developer group and I still get this error on Stored Procedures TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) ------------------------------ Property DefaultSchema is not available for Database '[HouseAccounting]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=DefaultSchema&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ The Developers can look at the properties of tables, views, and functions but not stoerd procedures. Tag: File System Watcher can not read excel from SharePoint
  - 8
    - data file blanks to nulls If you are using FlatFile source to read the data, try enbaling the checkbox that says "Retain null values from the source as null values in the data flow" in the Flat File Source editor. Hope this helps... Tag: File System Watcher can not read excel from SharePoint
  - 9
    - Send an email on non-fatal errors from Data Flow Bob Bojanic wrote: Hi Sandy, you should try to use Event Handlers. Event Handlers will allow you to build additional control flows that get activated by events (OnError, OnWarning, etc) posted from executables (a data flow in your case) you are monitoring. HTH. Bob, an error handler shouldn't fire (should it ) if Sandy is redirecting error rows in the data flow. Tag: File System Watcher can not read excel from SharePoint
  - 10
    - Service Broker "TO service could not be found" Message origin: "Transport" OK, I thought you might be onto something that I missed. While that may have been a problem - it didn't fix the issue. I still get the same message in Profiler on the target machine and no reasons in the transmission_status (empty). Any other ideas...anyone Tag: File System Watcher can not read excel from SharePoint
  - 11
    - Distinct Count with Junk Dimension Attribute Hi, It works fine when we are making Calculated Members, but when Analysis Services 2005 has introduced Junk Dimension Concept. So I feel it should give facility to add Distinct Count Cube Measure based on its [Junk Dimension] associated Attribute Dimensions. As per my understanding if there is Junk Dimension and we have very important Attribute Dimension, in Junk Dimension, On which I have to add Distinct Count Measure which can be used across all combination, In that situation we can not, because I can add Distinct Count only on JunkID which will be wrong or not of my use, As I have explained above. But we can add Several Calculated members as per our need. Thanks Bryan C. Smith for your suggestion overall it was helpfull. Bhudev Tag: File System Watcher can not read excel from SharePoint
  - 12
    - Trying to set output variable to row count result of SQL Execute Task Try adding an alias to the result column. SELECT count(*) AS ItemCount FROM hsi.itemdata a (The fact that it is an expression should have no impact. For testing I would stop using an expression and get it working with a static SQL statement, it often helps to simplify a problem process.) Tag: File System Watcher can not read excel from SharePoint
  - 13
    - How can I set SO_TIMEOUT on the sockets used by the JDBC 2005 driver? Thanks but I need clarification- The description of this method states that this is the amount of time the query will be allowed to execute. Is this enforced by the client or by the server Also- I see in the connection string properties there is a lock timeout specified as: The number of milliseconds to wait before the database reports a lock time-out. The default behavior is to wait indefinitely. If it is specified, this value is the default for all statements on the connection. Note that Statement.setQueryTimeout() can be used to set the time-out for specific statements. The value can be 0, which specifies no wait. So this makes me think that setQueryTimeout and lock timeout connection property are the same thing, but they are NOT the same thing. In my case, our customer is experiencing some kind of network condition that is not being propegated back to our code. The result is we have a transaction that is open (blocking) on the database that is waiting for a commit or rollback, but the driver never returns to our code. So this transaction ends up blocking other transactions. We have set lock timeout on the connection and this results in the second, third, etc. transactions to eventually fail with a lockTimeout exception, but the original transaction stays open still blocking. So what we want is a socket timeout (ex. SO_TIMEOUT in win32 api or socket.setSoTimeout in java) to be able to set this. If setQueryTimeout will accomplish then great, but if this just ends up adding a lock timeout then this wont solve the problem. Note as well that whatever this magical network condition is seems to be a problem for many database drivers running in windows (jtds, ibm db2, etc) and they all implement a socket timeout as a workaround. Thanks, Steve Tag: File System Watcher can not read excel from SharePoint
  - 14
    - xquery - order by problem Hi! Great, it does what I look for! Now I hope it solves my problem with sorting in Management Studio. If you now an good link about xml/xquery/xpath in Sql Server, pleas let me now (-: I read other examples on internet, and don't understand why my 1. try didn't work; Is it wrong, or has it something to do with MS implementation /Bjorn Tag: File System Watcher can not read excel from SharePoint
  - 15
    - Very hard question on how to query data and return by months sql 2003 Tag: File System Watcher can not read excel from SharePoint
  - 16
    - Database attach at setup Embedded database feature is only available in SQL Server Express. In express, in connection string you can mention UserInstance and attach mdf file. But in all other versions, you will have to attach the database using some sqlscript explicitly. And also connection string will differ in both method Refer this link for userinstance : http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx Madhu Tag: File System Watcher can not read excel from SharePoint
- Next
  - 1
    - how to set date field in sql server 2005 table You can see responses to your duplicate post here . Please avoid duplicate posting. This post is now locked. Tag: File System Watcher can not read excel from SharePoint
  - 2
    - SQLSTATE 42000- Error 15404 with ADS We are using the Local system account Tag: File System Watcher can not read excel from SharePoint
  - 3
    - HOW TO: Print a report directly to a printer OKay, I made some modifications to the whole class. This prints reports beautifully. Pass in parameters you want and it prints eihter in landscape or portrait. here is the code.. Imports System.Drawing.Imaging Imports System.Drawing.Printing Imports System.IO Imports System.Web.Services.Protocols Imports PrintReport.ReportExecution Imports System.Runtime.InteropServices ' For Marshal.Copy Imports Rockwood 'Custom object Imports Microsoft.reportingservices.Interfaces Namespace PrintReport # Region "Main" Friend Class Main Private m_sPrinterName As String Private m_sReportName As String Private m_sNumCopies As Integer Private m_aParam As ParamsDictionary Private m_bPrintOrient As String <STAThread()> _ Public Sub Main( ByVal args As String ()) Dim pe As PrintMain = New PrintMain() pe.PrintReport(m_sPrinterName, m_sReportName, m_bPrintOrient, m_sNumCopies, m_aParam) End Sub Public Property pPrintOrient() As Boolean Get Return m_bPrintOrient End Get Set ( ByVal value As Boolean ) m_bPrintOrient = value End Set End Property Public Property pPrinterName() As String Get Return m_sPrinterName End Get Set ( ByVal value As String ) m_sPrinterName = value End Set End Property Public Property pReportName() As String Get Return m_sReportName End Get Set ( ByVal value As String ) m_sReportName = value End Set End Property Public Property pNumCopies() As Integer Get Return m_sNumCopies End Get Set ( ByVal value As Integer ) m_sNumCopies = value End Set End Property Public Property pParam() As ParamsDictionary Get Return m_aParam End Get Set ( ByVal value As ParamsDictionary) m_aParam = value End Set End Property End Class # End Region # Region "PrintMain" Friend Class PrintMain Private rs As New ReportExecutionService() Private m_renderedReport As Byte ()() Private m_delegate As Graphics.EnumerateMetafileProc = Nothing Private m_currentPageStream As MemoryStream Private m_metafile As Metafile = Nothing Private m_numberOfPages As Integer Private m_currentPrintingPage As Integer Private m_lastPrintingPage As Integer Private mGlobals As globals 'Custom logging and error handling Public Sub New () mGlobals = New globals ' Create proxy object and authenticate rs.Credentials = System.Net.CredentialCache.DefaultCredentials rs.Url = My .Settings.ReportExecutionService End Sub Private ReadOnly Property mlog() As LogUtil 'Custom logging and error handling Get Return mGlobals.Log End Get End Property Private ReadOnly Property Msgs() As Messages 'Custom logging and error handling Get Return mGlobals.erMsg End Get End Property Public Function RenderReport( ByVal reportPath As String , Optional ByVal aParams As ParamsDictionary = Nothing ) As Byte ()() ' Private variables for rendering Dim deviceInfo As String Dim format As String = "IMAGE" Dim firstPage As Byte () = Nothing Dim encoding As String = "" Dim mimeType As String = "" Dim warnings As Warning() = Nothing Dim reportHistoryParameters As ParameterValue() = Nothing Dim streamIDs As String () = Nothing Dim pages As Byte ()() = Nothing Dim historyID As String = Nothing Dim showHideToggle As String = Nothing Dim execInfo As New ExecutionInfo Dim execHeader As New ExecutionHeader() Dim SessionId As String Dim extension As String = "" Try mGlobals = New globals 'Custom logging and error handling mGlobals.appName = My .Application.Info.AssemblyName 'Custom logging and error handling mGlobals.appVersion = My .Application.Info.Version.ToString 'Custom logging and error handling rs.ExecutionHeaderValue = execHeader execInfo = rs.LoadReport(reportPath, historyID) ' Prepare report parameter. If Not aParams Is Nothing Then Dim parameters(aParams.Count - 1) As ReportExecution.ParameterValue Dim i As Integer = 0 For i = 0 To aParams.Count - 1 parameters(i) = New ReportExecution.ParameterValue() parameters(i).Name = aParams(i).Name parameters(i).Value = aParams(i).Value Next rs.SetExecutionParameters(parameters, "en-us" ) End If SessionId = rs.ExecutionHeaderValue.ExecutionID ' Build device info based on the start page deviceInfo = String .Format( "<DeviceInfo><OutputFormat>{0}</OutputFormat></DeviceInfo>" , "emf" ) 'Exectute the report and get page count. ' Renders the first page of the report and returns streamIDs for subsequent pages firstPage = rs.Render(format, deviceInfo, extension, encoding, mimeType, warnings, streamIDs) ' The total number of pages of the report is 1 + the streamIDs m_numberOfPages = streamIDs.Length + 1 pages = New Byte (m_numberOfPages - 1)() {} ' The first page was already rendered pages(0) = firstPage Dim pageIndex As Integer = 1 Do While pageIndex < m_numberOfPages ' Build device info based on start page deviceInfo = String .Format( "<DeviceInfo><OutputFormat>{0}</OutputFormat><StartPage>{1}</StartPage></DeviceInfo>" , "emf" , pageIndex + 1) pages(pageIndex) = rs.Render(format, deviceInfo, extension, encoding, mimeType, warnings, streamIDs) pageIndex += 1 Loop Catch ex As SoapException Msgs.appendException(ex) 'Custom logging and error handling Catch ex As Exception Msgs.appendException(ex) 'Custom logging and error handling Finally Msgs.writeMessagesToLog( True ) 'Custom logging and error handling End Try Return pages End Function Public Function PrintReport( ByVal printerName As String , ByVal ReportName As String , ByVal PrintOrient As Boolean , Optional ByVal NumCopies As Integer = 0, Optional ByVal aParam As ParamsDictionary = Nothing ) As Boolean Me .RenderedReport = Me .RenderReport(ReportName, aParam) Try ' Wait for the report to completely render. If m_numberOfPages < 1 Then Return False End If Dim pageSettings As System.Drawing.Printing.PageSettings = New System.Drawing.Printing.PageSettings pageSettings.Landscape = PrintOrient pageSettings.Margins.Bottom = 0 pageSettings.Margins.Top = 0 pageSettings.Margins.Left = 0 pageSettings.Margins.Right = 0 Dim printerSettings As PrinterSettings = New PrinterSettings() printerSettings.MaximumPage = m_numberOfPages printerSettings.MinimumPage = 1 printerSettings.PrintRange = PrintRange.SomePages printerSettings.FromPage = 1 printerSettings.ToPage = m_numberOfPages printerSettings.Copies = NumCopies printerSettings.PrinterName = printerName Dim pd As PrintDocument = New PrintDocument() m_currentPrintingPage = 1 m_lastPrintingPage = m_numberOfPages pd.DefaultPageSettings = pageSettings pd.PrinterSettings = printerSettings ' Print report AddHandler pd.PrintPage, AddressOf pd_PrintPage pd.Print() Msgs.addInfo( "Report: '{0}' on printer : '{1}' for '{2}' copies completed successfully " , ReportName, printerName, NumCopies) 'Custom logging and error handling Catch ex As Exception Msgs.appendException(ex) 'Custom logging and error handling Finally Msgs.writeMessagesToLog( True ) 'Custom logging and error handling End Try Return True End Function Private Sub pd_PrintPage( ByVal sender As Object , ByVal ev As PrintPageEventArgs) ev.HasMorePages = False If m_currentPrintingPage <= m_lastPrintingPage AndAlso MoveToPage(m_currentPrintingPage) Then ' Draw the page ReportDrawPage(ev.Graphics) ' If the next page is less than the last page, print another page. If m_currentPrintingPage < m_lastPrintingPage Then m_currentPrintingPage += 1 ev.HasMorePages = True End If End If End Sub ' Method to draw the current emf memory stream Private Sub ReportDrawPage( ByVal g As Graphics) If Nothing Is m_currentPageStream OrElse 0 = m_currentPageStream.Length OrElse Nothing Is m_metafile Then Return End If SyncLock Me ' Set the metafile delegate. Dim width As Integer = m_metafile.Width Dim height As Integer = m_metafile.Height m_delegate = New Graphics.EnumerateMetafileProc( AddressOf MetafileCallback) ' Draw in the rectangle Dim points(2) As Point points(0) = New Point(0, 0) points(1) = New Point(width, 0) points(2) = New Point(0, height) g.EnumerateMetafile(m_metafile, points, m_delegate) m_delegate = Nothing End SyncLock End Sub Private Function MoveToPage( ByVal page As Int32) As Boolean ' Check to make sure that the current page exists in the array list If Nothing Is Me .RenderedReport(m_currentPrintingPage - 1) Then Return False End If ' Set current page stream equal to the rendered page m_currentPageStream = New MemoryStream( Me .RenderedReport(m_currentPrintingPage - 1)) ' Set its postion to start. m_currentPageStream.Position = 0 ' Initialize the metafile If Not Nothing Is m_metafile Then m_metafile.Dispose() m_metafile = Nothing End If ' Load the metafile image for this page m_metafile = New Metafile( CType (m_currentPageStream, Stream)) Return True End Function Private Function MetafileCallback( ByVal recordType As EmfPlusRecordType, ByVal flags As Integer , ByVal dataSize As Integer , ByVal data As IntPtr, ByVal callbackData As PlayRecordCallback) As Boolean Dim dataArray As Byte () = Nothing ' Dance around unmanaged code. If data <> IntPtr.Zero Then ' Copy the unmanaged record to a managed byte buffer that can be used by PlayRecord. dataArray = New Byte (dataSize - 1) {} Marshal.Copy(data, dataArray, 0, dataSize) End If ' play the record. m_metafile.PlayRecord(recordType, flags, dataSize, dataArray) Return True End Function Public Property RenderedReport() As Byte ()() Get Return m_renderedReport End Get Set ( ByVal value As Byte ()()) m_renderedReport = value End Set End Property Protected Overrides Sub Finalize() MyBase .Finalize() End Sub End Class # End Region # Region "Parameters Section 2 classes" # Region "Params Class" Public Class Params Private mID As Integer Private mName As String Private mValue As String Public Sub New ( ByVal id As Integer , ByVal name As String , ByVal value As String ) mID = id mName = name mValue = value End Sub Public Property ID() As Integer Get Return mID End Get Set ( ByVal Value As Integer ) mID = Value End Set End Property Public Property Name() As String Get Return mName End Get Set ( ByVal Value As String ) mName = Value End Set End Property Public Property Value() As String Get Return mValue End Get Set ( ByVal Value As String ) mValue = Value End Set End Property End Class # End Region # Region "Dictionary Class" Public Class ParamsDictionary Inherits DictionaryBase Public Sub Add( ByVal param As Params) MyBase .Dictionary.Add(param.ID, param) End Sub Public Sub Add( ByVal id As Integer , ByVal name As String , _ ByVal value As String ) MyBase .Dictionary.Add(id, New Params(id, name, value)) End Sub Public Sub Remove( ByVal id As Integer ) MyBase .Dictionary.Remove(id) End Sub Public Sub Remove( ByVal param As Params) MyBase .Dictionary.Remove(param.ID) End Sub Public Function Contains( ByVal param As Params) As Boolean Return MyBase .Dictionary.Contains(param.ID) End Function Public Function Contains( ByVal id As Integer ) As Boolean Return MyBase .Dictionary.Contains(id) End Function Default Public Property Item( ByVal id As Integer ) As Params Get Return MyBase .Dictionary.Item(id) End Get Set ( ByVal Value As Params) MyBase .Dictionary.Item(id) = Value End Set End Property Protected Overrides Sub Finalize() MyBase .Finalize() End Sub End Class # End Region # End Region End Namespace here is a sample form code to get it going. Private Sub Form1_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load txtRName.Text = "/Com/ElectronicInvoice" 'test default txtPrintPath.Text = "\\path\laserjet1150" 'test default txtNumCopies.Text = 1 ' default End Sub Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim oPrint As PrintReport.Main = New PrintReport.Main Dim args() As String oPrint.pPrinterName = txtPrintPath.Text.ToString oPrint.pNumCopies = CInt (txtNumCopies.Text) oPrint.pReportName = txtRName.Text.ToString Dim oParams As PrintReport.ParamsDictionary = New PrintReport.ParamsDictionary oParams.Add(0, "InvoiceNumber" , "S0606430" ) 'add as many paramters as you want or None at all. oPrint.pParam = oParams oPrint.pPrintOrient = True 'landscape = true oPrint.Main(args) End Sub Tag: File System Watcher can not read excel from SharePoint
  - 4
    - LAG MDX statement Cheers, I'll try that & get back to you. I had tried .CurrentMember with no success.... MemberValue hadn't occurred to me (!) Tag: File System Watcher can not read excel from SharePoint
  - 5
    - Looking for the equivalence (date issue) Thanks for that. It'll be tested. Tag: File System Watcher can not read excel from SharePoint
  - 6
    - How to make this DATE format im having some trouble getting this specifik date format: dd-MM-yyyy hh:mm where the time is in 24 hour format... Date and time formatting seems a lot harder in sql server 2005 than in access Tag: File System Watcher can not read excel from SharePoint
  - 7
    - Can't figure out this error! My logic is messed up. Execution was going to the "Else" portion on the rows it wasn't supposed to (that's why it was throwing the index out of bounds error). What is the syntax for "not like" Thanks Tag: File System Watcher can not read excel from SharePoint
  - 8
    - How to avoid non-published columns deletion on subscriptions' reset Hi Hilary, I have been doing some more tests with this, and I realized there is no problem with the identities. The real problem is since I changed the "Action if name is in use" to " keep the current object without changes" in the publication articles' properties, there is no replication. I changed this option to take default value, and the replication works again. But when I restart the subscription, the table at the subscriber's side is deleted, and I lose all the "unsubscribed" data. Is there any way to solve this Regards Tag: File System Watcher can not read excel from SharePoint
  - 9
    - Instead of INSERT trigger!! Hi, Thanks for your help. Well, I had an opinion telling me to: put begin ... end in each if block if ... begin ... end else begin ... end if I don't have them then if uses only the 1st statement What do you think Does both solutions give the same result Thanks Tag: File System Watcher can not read excel from SharePoint
  - 10
    - Urgt Pls:Cell merge prob Thanks for reply, I am using Table control to generate the report.eventhough My table does not contain any merged cells , the generated Excell sheet reprsents merged collums of data. regards Sithender.S Tag: File System Watcher can not read excel from SharePoint
  - 11
    - Referencing an alias in a where clause Its SQL 2000, and I haven't actually set the @project as any data type - could that be the problem The actv.projID is char. Actually, I may not have been clear in the problem. When running the data set, it will work fine, but when I try to preview the report, and enter a 4 digit @project, I get a blank report with no error. Thanks for the info on not using column alias! Tag: File System Watcher can not read excel from SharePoint
  - 12
    - Execute SQL Task: variable mapping failed with complex SQL script. Please help! You could also use an expression on the precedence constraint leading to the ExecuteSQL task. Tag: File System Watcher can not read excel from SharePoint
  - 13
    - MSSQL_REPL55012: An unspecified error had occurred in the native SQL Server connection component. Hi Ekrem, As I mentioned, I am a student and this is my first attempt at working with SQL Server. I am not familiar with what you mean by "configure Distributor, Publisher and Subscriber frame first." I can tell you that I am closely reading and executing each step of the walkthrough (link provided in my original post) in the order it is written. So far, I have done the following in this order: * Create a database and populate with data ( Successful ) * Prepare the Server for Publishing Data - Create the snapshot user account ( Successful ) - Create the snapshot folder ( Successful ) - Create a publication ( Successful ) * Set permissions - Set database permissions ( Successful ) - Grant publication access ( Successful ) * Create the Publication Snapshot - Create the publication snapshot ( Error occurs at this step ) If you think I should be completing/configuring something else, please let me know. I apologize in advance, but you'll need to explain to me what to do. Thanks again for your help Ekrem. It is much appreciated. Tag: File System Watcher can not read excel from SharePoint
  - 14
    - Log Shipping Thank you for the repsonse, I will test out in my dev environment. Regards, Sean Tag: File System Watcher can not read excel from SharePoint
  - 15
    - Move data to DB2 on AS400 with SSIS What is the error Also, you can't use an out-of-the-box solution against an ODBC destination. You are correct in using the OLEDB for DB2 driver. I use it for my source pulls, but don't use it for destinations so I'm not much help there without knowing your error. Tag: File System Watcher can not read excel from SharePoint
  - 16
    - sql server perfprmance Hi, I have table with 35 columns and 500,000 rows. I have a primary key on this table. when I retieve data with parameters (StartDate and EndDate) it is taking 1 minute on 2 GB RAM machine. how can I retrieve the data in lesser time say in 15 seconds. any help is appreciated. Thanks, Srik Tag: File System Watcher can not read excel from SharePoint

AU.T

I used file system watcher to read excel on my pc it worked fine, but when I tried to read the excel from SharePoint it did't work. The FileWatcher box showing the yellow color for long time that I had to stop the ssis.

So my question what is the cause of this. Do i need to set something or am i missing something Please help.

Re: File System Watcher can not read excel from SharePoint

AU.T

Plase

Re: File System Watcher can not read excel from SharePoint

DarrenSQLIS

What is the path you are using

I think of sharepoint files as being accessed via http, and of course it will not work for that.

Re: File System Watcher can not read excel from SharePoint

Rafael Salas

Have you try enabaling package logging and letting it run until it finish

It would be ggod to see what is reported in log execution.

Re: File System Watcher can not read excel from SharePoint

jwelch

They can be referenced by UNC paths (like \\my.server.org\sites\MySite\Shared Documents\myfile.xls) but I believe that only works if you are on the same network as the server - not over the web.

Re: File System Watcher can not read excel from SharePoint

AU.T

Thank you everybody. Sorry I used file Watcher Task, as provided on SQLIS.com, in SSIS and used UNC paths and http to connect SharePoint but it did not connect . Am i missing somethig Since if I used the watcher task to connect to my local computer it worked.

Re: File System Watcher can not read excel from SharePoint

jwelch

AU.T wrote:

Thank you everybody. Sorry I used file Watcher Task, as provided on SQLIS.com, in SSIS and used UNC paths and http to connect SharePoint but it did not connect . Am i missing somethig Since if I used the watcher task to connect to my local computer it worked.

Try making a connection using Execute Process to do a "net use" first - that will make sure that you can connect and have security permissions. I've also found that when using UNC paths to SharePoint, I usually have to make an initial connection to establish my credentials before I can access it programmatically.