Create your parameter @MyParameter
add it to Text data source as Select * from Mytable where myvalue = (@MyParameter)
Simple answers. Now.
Create your parameter @MyParameter
add it to Text data source as Select * from Mytable where myvalue = (@MyParameter)
=Format(CDATE(First(Fields!DueDate_SalesInvcHeader.Value, "DataSet_Result")),"dd-MMM-yyyy")
Use OLE DB Provider for SQL Server
Create Linked Server PERVASIVE using OLEDB Provider for ODBC
SELECT * FROM OPENQUERY(PERVASIVE,'SELECT * FROM mytable')
Rebuild your package, re-export a new excel
Check your data and confirm it's all valid data for each field you're trying to import
Disable the table triggers in the config package
LS Statements
Create missing accounting periods. This can prevent posting from completing.
Problem originates from too many transaction existing in the buffer entry.
Split up the statement into smaller time periods and post each out separately, every hour or 15 mins.
Try Post sales first, then post statement after
Try Disable cost posting, then post costs after
Check logs in
C:\ProgramData\LS Retail\LS Hardware Station
Uninstall hardware station
Delete C:\PRogramData\LS Retail\Hardware Station
Restart machine to clear any hardware claims
Reinstall Hardware station
Start service
Related errors: Cannot install licence, cannot find license file
Run BC install
Select your BC instance
Install SQL Server components