A small ETL solution that imports data from Excel files into SQL Server tables. Connection details are stored in project parameters (never hard-coded) to keep credentials secure. I will attach a SQL ...

I'm creating a DTS task in SQL Server 2000 that includes the following (so far). SQL Server connection that runs a stored procedure and returns a set of data. Excel connection to an excel file on my ...

Open the Import Linx solution in the Solution folder in Linx Designer. Open the Settings and set appropriate values for the TargetDbUser and TargetDbPassword settings. The TargetDbConnectionString is ...