If the Analysis Services instance that you need to provide access to is located on the local machine and installed as a default instance, there is no reason to change this setting. Otherwise, you need to specify the machine name and instance name ( mymachine\inst1). It...
Hi, I have two database: A and B, I would like to use SSIS to load the data from A to B. My dataflow consists of 2 steps only (load data from OLE DB resource and save data to OLE DB destination) and it seems like it's working but the process is very…
The account that runs the package as a job step must have all the same permissions as an account that runs the package directly, in order to access any external resources that the package needs to access. Otherwise, the job will not execute. You can use the existing SQL Server Agent Servi...
You can create an OLE DB connection manager and select the corresponding data provider from either the Connection Managers area in SSIS Designer or from the SQL Server Import and Export Wizard. Note On a 64-bit computer, you must run packages that connect to Microsoft Access data sources in ...
Thanks. I also realised that I need to use the following to access file attributes. Imports System.IO I'm working on this now, and will let you know if I can copy in same step where I set the file to "Not Read Only" lijnenjoost ...
When you are connecting to a web service from an SSIS Script component or transform using a WCF client, the normal method of configuring the WCF client from the application configuration file doesn’t work well. Your package will be running in some host, like dtexec.exe, and...
On a 64-bit computer, Integration Services installs the 64-bit version of the SQL Server Import and Export Wizard (DTSWizard.exe). However, some data sources, such as Access or Excel, only have a 32-bit provider available. To work with these data sources, you might have to install and...
The snapshot folder is just a directory that you have designated as a share. Agents that read from and write to this folder must have sufficient permissions to access it. This directory stores objects that are required by replication at the first node. This directory is not used by peer-to...
When you are connecting to a web service from an SSIS Script component or transform using a WCF client, the normal method of configuring the WCF client from the application configuration file doesn’t work well. Your package will be running in some host, like dtexec.exe, and you would have...
Access Code - DELETE Statement with DISTINCTROW and T-SQL Access Now() vs. T-SQL GETDATE() ? ADD and SUBTRACT depending on the condition is CASE STATEMENT ADD COLUMN to variable table? Add prefix in data column Add Time in SQL HH:MM:SS to another HH:MM:SS Adding a c...